DSXchange

This post may help you

viewtopic.php?t=83888&highlight=type+19+files

Or just have it do both lookups and check them in the proper order. The 'condition' is enforced by the order you check each link for success. Hi Chulett, ekareem wants to get the data from the two different Hashed lookup files (not from the source). Do you mean that its possible through only one ou...

If data is single column then using stage variables you can achieve it (using a single target link). If it's not then you would need to create three links from the transformer writing to the same target. First link would be used if NOT(lkp1.NOTFOUND) is ture. Second link would be used if lkp1.NOTFOU...

The tool would be isql.exe or osql.exe

Hi All, I am testing jobs of a certain category, for that I have created one server job which runs each job one by one (i.e. one after the other) through DSRunJob. My requirement is to abort a job running for more than certain time (say 20 minutes) from within the master server job. Moreover I can't...

Error: <JOB NAME>..<STAGE NAME>: [IBM][CLI Driver][DB2/6000] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=279, TABLEID=11, COLNO=21" is not allowed. SQLSTATE=23502 What is TBSPACEID, TABLEID, COLNO? Where can I find these columns from DataStage Administrator? Which ...

In place of

DB2_Sales=AS400_Sales

Use

DB2_Sales : "" =AS400_Sales : ""

This will make sure that comparison is of strings not of numeric values.

I have been checked in the uvconfig file but I didn't see any configuration. Where can I increase the numeric value size. Search EXACTNUMERIC in uvconfig file, you will find it there. I am trying to compare the sales data result. First I substract the values like (DB2_Sales-AS400_Sales).This values...

Can anybody help me in the following error/warning to find out from DataStage Administrator? Help me to write SQL. I am unable to find from which metadata will be provide for the following error/warning. Error: <JOB NAME>..<STAGE NAME>: [IBM][CLI Driver][DB2/6000] SQL0407N Assignment of a NULL valu...

Hi All, I have being one more problem encounter. Now I am trying to validate the data across DB2 and AS400 after loading the AS400 data to DB2 datawarehouse. One of the column is sales data column.I try to chk the data by substracting the data from (summation of DB2 - summation of AS400) .The subst...

1st entry: From previous run DataStage Job 1512 Phantom 14950 Program "DSD.RUN": Line 2081,Variablr previously undefined.Zero length string used. Program "DSD.RUN": Line 2081,Variablr previously undefined.Zero length string used. jobnotify: Unknown error [149556] DSD.StageRun J_...

Hey try this also (on your own risk) If the category is at the parent level Delete from DS_JOBS WHERE NAME ='\\\catname' Where catname is the name of the category. else Delete from DS_JOBS WHERE NAME ='\\\catname1\catname2\catnamen' Where catname1, catname2,...,catnamen-1 is the hierarchy of the par...

hi DSguru's , i have a job which extracts 3 lakh records, when loading, after 55,000 rows the job gets aborting , and these 50000 records are inserted in the target, how can i load the target from the 50001 record . i am using datastage 7.0 , the transaction grouping checkbox is not avaliable in th...

I had unknowingly left the field where you specify the table names in MSOLEDB stage blank. I was using a user defined sql query but the MSOLEDB stage still requires something to be present in the table name(s) field for the job to run successfully. Its wierd because i use some other stages like Inf...

Hi Forum, Firstly, Thank you all for helping me so far. Its simply gr8 :) Secondly: I have searched the forum before posting this problem, Igot lots of matches, but nothing helped.(keyword I used Longvarchar) Now the problem, I have a job in which I am populating the contents of a SQL Server table t...