DSXchange

well i am trying to execute this query in AQT ( advanced Query Tool ) directly on DB2 . Well pardon me , probably the example i gave was wrong, well my sql should output about 15 columns . The other sql as well should output the same 15 columns but after doing a union with some other table . But the...

Let me explain the senario, i have 3 jobs which almost the same . the only difference the number of records that is being pulled . Hence i thought i could make them all as one job and parameterize the job so that the db2 stage selects the right query depending on the parameter value that i pass. the...

when i run the statement 1 i get this error 42601(-104)[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "1" was found following "Select if (Select ". Expected tokens may include: "<space>". SQLSTATE=42601 (0.15 secs) and when i run statement 2 i get this error ...

Hi All, I have a senario where i need to execute different sql based on the parameter value that i pass. i tried using case statement and also if statement , but having problems executing the statement. the statement i used was IF statement : Select if (Select 1 from sysibm.sysdummy1) =1 then (Selec...

Hi All, I have this senario where i am getting the updated file for the month from the source . I had to check if the updated source file had any records which already existed in the table that i am going to load cause i need to reject those records and pass the once that do not exist into the table...

to add to it i do the null check in the constrainst first so as to bucket all the records with the JC_CNCT_CUSTOMER_NO as null as well as to set an indicator if the condition is true in the column derivation
the datatype for JC_CNCT_CUSTOMER_NO is varchar(6)

the expression i gave for null checking is as follows

(IsNull(TRIM(DSLink2.JC_CNCT_CUSTOMER_NO)))

where as the datatype for the element JC_CNCT_CUSTOMER_NO is varchar(6)

i have used the transformer stage before in other jobs. I have observed that , in one of the condition i had given , i was checking for the field being nullable in the if condition ( this is in the constrainsts of one of the links from the transformer) when i removed just that condition alone the jo...

though there is no error the job is not compiling
could you please help me resolve this issue?

Hi All, I have this job where i am trying to capture only the error records in a file . i have given all the conditions to capture the error in the contraints of the trasnformer. But i'm getting the compilation error which says Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 18:...

Hi , I have been having this issue with the jobs , any updates(change the transformation to the field) i make to the job , i make sure i save it and complie it . But when i run the sequence which incorporates this job , look slike the updates i i made to the transformation is not taking effect . I s...

Hi All, I have this file which has a field of type char(8) . i need to convert this into decimal[7,2]. Well i am using stringtodecimal() funtion in the transformer right now . It seems to work perfectly fine all most of the records and just in case if the filed had any value which could not be cnver...

Hi All, i wanted to know how to delete multiple datasets in one command line . I did go through couple of posts but dint find any soultion for my requirement . Most of our intermediate datasets are stored in one staging folder and we have several datasets . now we need to delete all of these datsets...

I have this job where i am reading a file with 10 fields of which one column which should be in signed decimal form the data looks like this 000000{ 009600A 034566} and this should be stored as decimal(7,2) and the out put should look like 00000.00 00960.01 -0345.66 I tried giving something like thi...

i'm sorry about my typo

we are running on 4 nodes