DSXchange

I want to start Job2 if Job1 finishes successfully with or without warning. I do not want to use Sequencer in between and use two different trigger conditions as you said. Can I make the trigger condition of Job1 as 'Custom' and specify the following : Job_Activity_0.$JobStatus = 'DSJS.RUNOK' Or Job...

In a Job sequence :

Job1 -> Job2

When I specify 'OK-(Conditional)' in the Trigger condition of Job1 and Job1 finishes with warning, does that mean Job2 will not start.

In other words ,

Is 'OK-(Conditional)' takes care of job finishes successfully with or without warning.

Does anyone have solution to this.

Thanks.

I have a dbout regarding the 'Wait for file' activity stage in DS.Suppose I am getting a remote file through FTP. Now, think of a situation where the file hasn't come in full and 'Wait for file' detects the presence of a file and fires a subsequent job. So, does 'Wait for file' waits for the receipt...

No, I have just one column name defined in the output link. Still I am getting the same (metadata mismatch) error. Because in SQL I am retrieving 2 columns whereas in column definition I have only 1 column.

Ray & Narasimha, I did the way you mentioned.Transformer output only name (and not id ).Within DB2 API, I am generating the id using the sequence INSERT INTO MYSCHEMA.TEST1 (id,name) VALUES (NEXTVAL FOR MYSCHEMMA.X_SEQ,:1) But since Column definition in DB2 API contains only ' name ', so writing...

By 'User defined SQL', do you mean Custom SQL, then thats what I am trying. Seq File -> Trnsfrm -> DB2 API (table TEST1) TEST1 table contains columns id,name I am generatng id through DB2 sequence and need to bring name from input. Will my custom SQL inside DB2 API look like this insert into MYSCHEM...

I have a requirement to run a DS job on last day of every month (and not on 1st day of next month). Now the last day date can be anything between 30,31,28,29 etc).

How do I schedule that job through Director.

I have a DB2 sequence created in database.I want that to be used in my target DB2 API stage (like NEXTVAL FOR MYSCHEMA.X_SEQ).Can I do that?

yes, I have connected to DB2 while using DB2 API stage, but the connection seems to be not working here.I have checked the username,password,client instance name. Is there any other method to debug the stage (as I don't find any option such as view data etc).

I am using a Surrogate Key generator stage.It runs fine with with a source type = 'File'.But when I am using the Database(DB2) sequence, the job aborts with error : Surrogate_Key_Generator_1,1: Error Idx = 1; DB2Driver Embedded SQL message: ; sqlcode = -1390; sqlstate = Surrogate_Key_Generator_1,1: ...

Does anyone have any idea of what is going wrong here (Error message shown below): A *** ERROR => RFC ======> CPIC-CALL: 'ThSAPCMRCV' : cmRc=20 thRc=223 CPIC program connection ended (read error) [abrfcio.c 8139] A *** ERROR => RFC Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 3295 CPIC-CALL: 'ThSAPCMR...

When I run my DS job with Idoc Load stage it does generate some .idx and .dat files on IIS server. However nothing is shown in SAP side, tried all SAP transactions like WE02 etc. I have partner,destination partner,RFC etc configured in SAP and working correctly.Still it seems SAP box has no knowledg...

Even if you have sequential mode input like

Seq File -> Aggregator-> ...

then also, aggregator will run on 3 nodes and find the aggregation for each partition.

Ray, I am not sure whether I got your point correctly.

1.How to form the array in Datastage side (from the set of incoming rows)?
2.Will the array contain all columns or just the column required for lookup.