DSXchange

remaining are also same design, all are finishing there is no dependency thats why we are triggering all 7 seq's parallely but only this sub seq is hanging. it's not triggering inside jobs but remaining sub seq's are doing fine. all 7 are same design and same approach. only this sub seq is not trggr...

Hi, Parallel job is hanging while excuteing through master sequence Parallel job is attached in one sequence and that sequence is attached along with 6 more sequences in one master sequence and we are calling master sequence from unix script. it is triggering all sub sequences and all are finishing ...

Thx Kumar, As per my knowledge we 2 options to overcome this , but @ field level option we have problem with maximum length and maximum number of fields and secomd one is file properties there I was succeded in Old project but now it's not working and it's throuning that warniing, If it should be sa...

I am loading data into sequential file , while loading null values I am getting below warning

Sequential_File_2: When checking operator: When validating export schema: At field "A": "null_field" length (0) must match field's fixed width (3)

Thanks in Advance for your suggestions

Hi, Some jobs means one folder of jobs are changed as readonly and we now we are not able to change and compile that jobs. pls help me how it happened lik this is there any chance while exporting and importing is there any chance, Environment is we are changeing code @ offshore and import to preprod...

Hi, I am getting following fatal error for parallel job which is extracting data from data set and loading into Oracle table error is " main_program: Could not check all operators because of previous error(s) [api/step_rep.C:1144]" But thers is no errors at all this is the only error, and ...

Hi, This job is working fine in normal environment, But it's aborting in GRID environment. It's thorning following fatal error " Trgt_Rej_data_FF: No conductor nodes found in export node pool. [new-impexp/file_export.C:491]" job scenario is : it's reading data from SAP and loading into ora...

HI , I am using lookup stage in parallel jobs to check referential integrity so, It's giving following error " LookUp_3: Error when checking operator: Key field "KNA1__GMC_ZZBAC" not found in input schema [keylookup/keylookup.C:177]" eventhouh the filed is there at source but it'...

Hi, While excuteing routine excute.sql of to excute sql query's in routine I am facing below problem. TEST #1 ******* Arg1 = SELECT * FROM PROCS_LOG Arg2 = gmodc Arg3 = gwmoraods Arg4 = gwmoraods Test completed. DSLogInfo called from : ExecuteSQL Message to be logged is... > SQL State = 08S01, DBMS ...

I don't want to abort that master sequence if any subsequence aborted,But while restarting it should excute that failed subsequences only. In this case how can I do.

Thanks In Advance

Hi Andrew, Yes I have that folder in side that there is no routine for "excute.sql",I have routines inside that for "excute.SH,excute.TCL" So, For me there is no routine for "EXCUTE.SQL" Can any one tell me how can i Proceed and how can i get that routine and how to Sol...

Hi Meena,

I posted my total routine code pls gothrough that and if you and find anything pls let me know

Thanks in Advance

And I have a file called "D_DSU_BP.O" there is no folder under how i can add "DS.EXCUTE.SQL" AND HOW CAN I DO THIS PLS LET ME KNOW

I am using some other routine only, But i compiled successfully and where I can change that prototype fo that routine. pls see below code of my routine " $Include DSINCLUDE JOBCONTROL.H Deffun ExecuteSQL(SQLSTMT,DBDSN, DBUSER, DBPASS) Calling "DSU.ExecuteSQL" * /home/dsadm/Telstra/par...

It's completed remaing without aborting,
The main sequence status is allways FINISHED only..that should be as current design, In that case wat i need to take care