Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is it possilbe to call a store procedure inside another SP
Inside a store procedure, I want to call another SP several times and insert the result into a table, is that possilbe? If so, how should I do that? Thanks, -
Help on load text file to db2
1. create a table SOURCE with 5 Varchar columns (F1,F2,F3,F4,F4 with length at least 30) 2. load your text file to the new created table, please use "MODIFIED BY COLDEL," only, no character delimiter 3. create table A (4 columns), B (2 columns), C (4 columns) 4. do three INSERT by selecting the... -
can I make current timestamp to be part of the export file name?
If it is possible, how to put the current timestamep to be part of the export file name? -
Is it possible to export multiple select statement into one flat file?
Those select statements don't have the same number of records. For example, the first select only retruns a lable and the number of recrods; the second one is the real data extract. Is it possible to concatenate them together and export to one flat file? Thanks
