Home > IT Answers > Business Intelligence > Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
Mdshadabalam
55 pts.
 Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
DB2, Qshell, QTEMP Library, SQL procedure
i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

Software/Hardware used:
ASKED: July 6, 2010  6:27 AM
UPDATED: July 5, 2011  1:58 PM
RELATED QUESTIONS
Answer Wiki:
when using QSH, your requests are federated to a separate job. this means that your local QTEMP is not the same as the QTEMP in that particular job. So it won't work. as you say, you have to use a named library.
Last Wiki Answer Submitted:  July 6, 2010  1:16 pm  by  Adamwkiuk2002   215 pts.
All Answer Wiki Contributors:  Adamwkiuk2002   215 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

I am agree with Adam Reply.

Mdshadabalam
 55 pts.