DSXchange

Chulett the error which I posted in previous is for user define SQL where I am unable to view the data from view and unable to run the job but when I am using auto generated SQL I am able to view the data but unable to run the job. For both user define SQL and auto generated SQL options job is getti...

I have search in forum for $dsp.open error -100 they said this error might cause because of invalid sql or invalid column name or invalid datatypes i have check all the above requirement they are fine but still i am unable to view the job as well as i am unable to run the job also i mean job is gett...

hey chulett sorry i have pasted the view data error in earlier post. when i am running the job here is the error get generated APT_CombinedOperatorController,0: Failure during execution of operator logic. APT_CombinedOperatorController,0: Fatal Error: Fatal: This SQL statement did not contain the sa...

But when i am trying to run the job with auto generated sql job is getting aborted and giving the message [0001]DB2_UDB_Loading_Job..DB2_UDB_API_1: [IBM][CLI Driver][DB2] SQL0206N "ORCHESTRATE.CONTACT_ID" is not valid in the context where it is used. SQLSTATE=42703 [0002] DSTAGE-DB2CLI-002...

Hey surya

actually i have some documentation on db2 z stage. If you can send me your mail id so that i can send you the documentation.

Hi, Actually i am trying to load the data from sequential file into db2 database using DB2 UDB stage. But i am trying to view data i am getting the following error:Actually when i use auto generated sql and try to view data i can view it but with user define sql i am getting this error as mention be...

Hi, I am trying load the data into db2 database which on main frames from sequential file using db2 z stage under properties tab it got so many options such as Job Flow: SEQ_FILE--------------------------------->DB2Z_STAGE mode= append table name=abc database name=123 database password=456 database ...

why i will run the job without compling??? my problem is when i am trying to complie the job status of the job is complie state. Never ending the complie state at all

Hi novak, thanks for your replay, actually i had set up the APT_COMPILEOPT and APT_LINKOPT earlier as you mention below and ran the job still i am unable to complie the job. Job is getting hanged.actually the visual studio 2003 which i have installed is supported to x32bit but my operating system is...

Actually i have searched the dsxchange and ibm db2 form also but i could not exact solution. I got few tips to rectify the error in detail but unable to solve it

actually the error is throwing by db2 bulk load. when i run the job bulk load job .bat files are created but the status of the job is aborted but when i run the .bat file manually all the rows are inserted into db2 database. it is working like wired still working on that to figure out the problem

I have set the $APT_DISABLE_COMBINATION to true iam getting the same error as mention above

I have set the dshome path = c:\IBM\InformationServer\Server\Engine in datastage administrator and i am trying to view the data from db2z stage i am getting below error: ##I IIS-DSEE-TFCN-00006 18:29:55(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=NSADS-DEV2; -m=Pentium ##I IIS...

I have set the dshome path but how do i need to add database information in dshome path or how do i set APT_respath

hey please can you help out with setting apt_respath and dshome path so that i can use db2z stage for loading data