DSXchange

You guys Rock ....

Thanks

Hi Gurus , How do i write multiple conditions in a routine? i need it like mentioned below , but i am getting compile errors when i do it like this. I tried putting all 3 conditions in brackets , tried comma , semicolon at the end still gives compile errors. If Status = DSJS.RUNFAILED Then ErrCode =...

Thanks Ray,

I changed the column from non-nullable to nullable .Issue resolved.

Hi Everyone, I am having similar issue with memory as noted here. I have several lookups in my job design . buffer(2),0: Fatal Error: waitForWriteSignal(): Premature EOF on node xxx.com Interrupted system call Lkp_stage,0: sendWriteSignal() failed on node xxx.com ds = 22 conspart = 0 Broken pipee Lk...

Hi , If IsNotNull(Trim(Lnk_Lkp_Get_MatlGrp.EKKO_BSART)) = 'ZZPM' then Lnk_Lkp_Get_MatlGrp.EKPO_MWSKZ Else SetNull() Above code I am using in the transformer derivation I realized that this issue is with "handling nulls and trims together" and need to resolve this issue Thanks everyone for ...

Hi , In my job I am using several lookups and Xfm stage Please give me some idea on How to identify the issue ?? Thanks in Advance APT_CombinedOperatorController,0: Fatal Error: Null value on the accessor interfacing to field Below is the compilation error message showing in transformer stage . [Out...

Chulett thanks for the reply, my input files has datastage job names and i have a server job which reads the file and runs the job in the file. We are now getting a request for using multiple files with multiple job names, i didnt see any option in server jobs to handle file patterns, if my server j...

Is there a Parallel routine or function equivalent to UtilityRunJob server routine? I need to run a datastage parallel job from another job.

Hi everyone, I am getting below error Joining two tables (A ,B)using LEFT OUTER join in DB2 connnector stage. Keys:FIELD1,FILED2,FILED3,FIELD4,FIELD5 All fields defined as null expect FIELD5 defined as NOT NULL A-LEFT table ,B-Right table DB2Conn,0: Fatal Error: Attempt to setIsNull() on the accesso...

Ray , You are D Man. Tested the concept and it worked exactly as needed. Thanks for the Information.

Ray , Thanks for the response. The sequencer has an email activity which notifies about the Completion status to the user.

Could you please explain in detail about "cloning and adapting UtilityRunJob"...

I am invoking a Sequencer though a Server job by using the DSUtilityRunJob. But this server job only completes after the Sequencer call is complete , is there a way i can get the server job to complete without waiting for the sequencer to complete?

Thanks chulett Work around ..I meant here is to do with different format for date. Now I have different format of string as INPUT (Sequential file ) :YYYYMMDD VARCHAR 8 TARGET DB2:DATE (4) Transformer function used : StringToDate(Input.column,"%yyyy%mm%dd") Also I tried using Substring Inp...

@chulett

I changed my input format to 11/03/2012 (mm/dd/yyyy) and re-ran my job ..now I don't see any issues.

I will do more work-around on these dates and keep posted

Thanks

Hi , I am reading the date field as Varchar using Text file . Input format: mm/dd/yyyy Target :DB2 database -DATE format Trasformer logic : StringToDate(Input.DT,"%mm/%dd/%yyyy") Error message : APT_CombinedOperatorController,0: Data string '11/3/2012' does not match format '%mm/%dd/%yyyy'...