DSXchange

Hi ,


Thanks guys for solving my problem.






SomaRaju

Hi whale,

Its a server job sorry for posting in parallel and one more thing where should I give the constraint length() is it at the DB2 API stage or at the sequential file
what I have to give constraint like length(column) > 12



Thanks,
SomaRaju.

Hi, I have a job and iam loading some records from a file to a target DB2 table and iam using DB2 API stage and it has a Rate column and it has decimal (12,2) but some records are dropping because they have more than length decimal (12,2) is their a way so that I can filter out records that have mor...

Hi, When Iam trying to open a DataStage Designer. Iam getting the following error Error calling subroutine: DSR_PROJECT (Action=7); Check DataStage is set up correctly in project RT (The connection is broken (81002)) How can I overcome this error . By stopping and restarting the DSEngine can I over ...

Hi kumar_s, I checked the disk space utilization of /DataStage/751A/Ascential/DataStage/Datasets and I got Filesystem 512-blocks Free %used Iused %Iused Mountedon /dev/Datastage1 60030976 23932992 61% 226555 4% /DataStage I dont know what temp directory you are saying about is it Scratch space and f...

Hi Kura, I type ulimit -a command . When I entered the command I got the output as given below. time<seconds> unlimited file<blocks> unlimited data<kbytes> 131072 stack<kbytes> 32768 memory<kbytes> 32768 coredump<blocks> unlimited nofiles<descriptors> 2000 file<blockd> unlimited . I already posted i...

Hi, Iam having a job which reads data from three source tables using DB2 API stage and I have join stage and I am joinning the three tables by a inner join for commom columm RCA and writting the output from a join to a dataset. The job run fines if the output from a join is 974197 records but if the...

Hi Narasimha,


There are no constraints defined in the job it is direct mapping from Transformer to DB2 API stage .





Thanks,
SomaRaju

Hi Chullet,

The jobs are ran from Datastage Director and Transaction and Array size was given as 50 and 100 respectively in DB2 API stage . Do you think the rows are not commited because of the above settings.



Thanks,
SomaRaju

Hi DSguru, Yes you are right Iam not getting any warnings in the log . Iam trying to rerun the job and see the result this time and if Iam having same issue then I will load in to a file as you mentioned after loading in to table I mean I will add a link to a file after the link that loads the table...

Hi Dsguru,


Iam using DB2 API stage and I have selected insert rows without clearing option





Thanks,
SomaRaju

Hi , I have a job which is loading records in to Price table , and when I ran that job it showed me in the log that 259964 rows written to To_Prc_Tbl where To_Prc_Tbl is the link name that is given to insert price table. When I see in the database by quering the number of records in Price table it i...

Hi , I have a server job . Iam loading price records from sequential file to the target database DB2 using DB2 API stage . When Iam loading a price value which is 11,165.70 from file to an DB2 table it is loading as 11,165.00 and it is loading .00 instead of .75 . I mentioned in table definition for...

Hi "ArndW",


I changed to other file system which is not full as I mentioned in the post it was only used 48%




Thanks,
somaRaju