DSXchange

Thanks Ray and chulett,

I didn't give any limits during run time for both warning and row tabs, also no values like abort after this much rows has been processed in job level.

Thanks, Ragu

Hi, My job failed due the following reason after processed around 35 millions of data and for this job took 24 hours of time. Abnormal termination of stage JOBNAME.STAGE_NAME detected Also I reset the job and it did not give any other error message. Job design is very simple only Seq file Stage ----...

hi,

CurrenTimeStamp() - DS Function - how to make this return date in particular format (including microseconds)

like 2007-10-10-09.05.00.621621676

in datastage ..by default date gets generated in this format..
2007-10-10 09:05:00

Thanks, Ragu

Hi.. Currently we are developing our jobs in server(Datastage version is 7.5.1.A). Comming jobs we have a plan to do in parallel. So i did a sample job in parallel. In this i get some records from row generator stage and simply pass to transform and transform to peek. when i try to compile this one ...

Hi ray..

Yes, the environment variable was defined in the DataStage Administrator.

I search by using thee String -- "How to read Environment variable in routine". I found few posts. but i did't get clear idea from that. can u help me pls.

hi Guys,


Can we call a environment variable(User Defined) in a routine. Will it be possible. Can anybody suggest on this.

Thanks in advance
Ragunathan J

HI..

Use "stored_Procedure" stage, which is present in database palate.

Hi..

Use this command "dscmdexport.exe" in command prompt and give the needed parameters.

Hi.. Actuly i write a records into flat file, using sequential file stage as "Pre_CDC_namedPipe_write" And also read records from same flat file , using sequential file stage as "Pre_CDC_namedPipe_read" by parallel. when i was run this job i get the following error. Fatal ds_setu...

Hi..

I got a fatel error in my server job.

"Pipe Broken"

Any one help me pls. why it is come.

Regards,
Ragunathna J

Hi chulett , i would like to thank for reply. we r running the dsjobs in the unix command window. It is return job status externally ,My Requirement: the corresponding output will assign as a user defined variable. for example: i will run the shell progrmm and output of this program generate some st...

Hi....

I Run a DS Job in unix shell programing use "dsjob -run" command. After Execute this command i got "Status code = 0" like. I need to assign that Status code into a variable.

Thanks in advance.

Regards,
Ragunathan J

Hi,

How to access DB2 cmd editor from shell script.

Thanks in advance.....
Regards,
Ragunathan J

okay, lets go further then. Is this a dataset or a flat file? Is the datastaqe server and database in the same time zone? Is the output server in the same time zone as datastage? Is the Datastage client in the same time zone? What timezone is all of the above? (I've seen date differences from US to...

Did you check for triggers? What is the column definition of the date in the table vs. the definition in DataStage? Are you extracting from the table using a select * or select Col name, or select coalesce(colname,'2000-01-01') Or anything like that? How do you specify the date files on the sequent...