DSXchange

Hi Chullet,

Here is i have my input column1 have 'USD' and second column2 have 'GBD' so based on first point i need to get column2 value 'GBD'
becuse it is in firsr alphabatical order, how can we do in datastage job?

and my input data is dabase table.

Hi All, I have two coulmns column 1 and column 2, i need to get the records in first and second alphabatical order 1)Select 'column1' or 'column2 'based on which value populated comes first alphabetically 2)Select 'column1' or 'column2 'based on which value populated comes second alphabetically 3)Se...

Use APT_RDBMS_COMMIT_ROWS for DB2. Default is 2048. ... Hi Chulett, I tried the option you mentioned set, APT_RDBMS_COMMIT_ROWS=500000 and also tried with Insert array size=500000.... still job is failing with same reason. Any other options?? FYI The log size is set to 25GB in DB2.. Error: Failure ...

Upsert method:Delete only
delete FROM schema.ABCtabl
WHERE DATE(TIMESTAMP) <current_date - 42 days
close command:Re org the table

Hi Friends, I am facing a serious issue in production. There is a job which deletes records from a table every week end from datastage using ODBC enterprice stage. Target DB:DB2 V9X Records to be deleted every time:around 7.5 million total size of the table: 18.5 million records Failing with the rea...

I added this variable in administrator/Use defined and later imported to the job under job properties-->add env. variable... I set the default value to '.'

Still its failing with same error.

Thank you for the response

No.its just a straight move and am not applying any functions.
The variable you mentioned above is not available in the datastage 8.1(I don't see this in job properties-parameters-envirnoment variable)

Hi , I am trying to update 3000 records from dataset to DB2 table.(dataset-->XFM-->odbc connector) but I am getting the following error and job aborts.I have 12 I/p fields and I can update without any failure if I remove decimal fields.but with decimal fields, its failing I/P field A =Decimal(18,2) ...

We are reading an EBCDIC data file successfully with cff stage but there's one issue- not able to use constraint on the Output tab with a job parameter. The requirement is to filter out certain records and if I hard-code the value it works fine but not when I use a job param. Funny thing is the drop...

Hi My incoming data is this way m/dd/yyyy ,mm/d/yyyy, mm/dd/yyyy, m/d/yyyy so the target should be in this format yyyy-mm-dd(datastage default format). For m/dd/yyyy if there is 2/24/2011 then i should populate it as 02/24/2011 For mm/d/yyyy if there is 12/2/2011 then i should populate it as 12/02/2...

Thanks for the responses. I'm unsure whether I can write to a file and read from it as the params are passed via a UNIX script.... And to answer the frequency of reset Q, I'm not sure about that one either. All I know is that they have to be unique for every run and there may be thousands of run for...

Yes, that is correct. For now I have only 2 params; file name and unique identifier. So if the job reads 4 files, I'll have to pass 4 file names (which the loop handles) plus 4 different values for Identifier that will be passed to the job inside a sequence....

Thank you for unprotecting it and apologize for the delayed response. The "list of things" seems to work fine as the loop goes over as many items as I have. But I seem to be unable to pass different parameters to this Job Activity. For example, every run will have a unique identifier that ...

Hi I am getting a warning when using oracle connector The connector was configured to run in parallel mode on 8 nodes, but the partitioned reads were not enabled. The connector will run in sequential mode. Then the job is getting aborted with error as Parallel job reports failure (code 256) Please c...

Sorry..... I'm unable to see your entire post. Is there anyway I can do that without the price tag? Thanks!