Home > IT Answers > Development > can a file be loaded from an embedded sql statement?
Cansler
50 pts.
 can a file be loaded from an embedded sql statement?
SQL, SQL statements
can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

Software/Hardware used:
ASKED: August 28, 2008  6:28 PM
UPDATED: August 29, 2008  1:18 PM
RELATED QUESTIONS
Answer Wiki:
Hi, You can retrieve data from a file using embedded SQL, is this what you mean? You will need to declare a "cursor" and do a fetch to get the data. Regards, Martin Gilbert. Martin, I need to load a work file based on several search criteria, and then use the file to display in a subfile.
Last Wiki Answer Submitted:  August 29, 2008  1:18 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What database platform are you using?

Denny Cherry
 64,505 pts.
 

I am trying to do this on a AS400 platform.

Cansler
 50 pts.