DSXchange

Hi Shiv, This can be achieved reading the input file (hope this input can be written into seq file) in the job control code and reading the records in the loop. OpenSeq/ReadSeq/WriteSeq would help you reading/writing from/into the file. And last value to be incremented till you reach the target rang...

Hi,

Search for DSGetLogEntry & DSGetLogSummary routines in DS help and Log of a job can be obtained using these functions.

HTWH.

Regards
Saravanan

Hi,

Search the forum (Update SDKsequence is the keyword) and you could find few posts as this topic covered many times.

Regards
Saravanan

Hi Sandy, Created a test job and load the data into a DB2 table using DB2 API stage. Defined a parameter as rundate (2005-09-11) with the data type 'string' and map this rundate in the transformer and it loads the data into DB2 table. This column defined as 'Date' data type in DB2 table. It works fi...

Hi,

Did not specify the data type and format of the parameter in my previous reply. The datatype of the parameter is string and format is 'YYYY-MM-DD'.

HTWH.

Regards
Saravanan

Hi,

Define the column as varchar in the target though the column's data type is date in the database and map the parameter. Then you should be able to load the data into the table without the problem.

HTWH.

Regards
Saravanan

Hi,

Any Stored procedure can be called before/After SQL tab of the any DB stages and if you want to execute the stored procedure, you might need to use BCI calls to call SP.

HTWH.

Regards
Saravanan

Possible cause of the problem is the required libraries are not loaded due to the LIBRARY PATH in the environment variable. Check the LIBRARY PATH variable is set in DSENV file, if yes execute the DSENV from your $DSHOME directory so that all library path would be set then try executing the command....

Hi,

Alternatively, you can 'UtilityWarningToLog' or 'UtilityMessageToLog' routines from transformer.

HTWH.

Regards
Saravanan

It seeems to me, the concatenation of those three files did not happen. So ensure that your cat operation is successful so that file d can be used as input.

Is there any error/warning messages in the log?

Regards
Saravanan

We had the same requirement in my earlier project. We split the source into 2 as you mentioned in your first logic, which is type 1 and type 2 columns and used Change Capture stage to identify the delta. Would recommend the method 1, which would be easy and easy to maintain as well. Regards Saravanan

Thanks Ray for your suggesstions. I do not think i can reproduce this problem. I will look into this locking when i encounter the problem like this.

Regards
Saravanan

Hi Snassmir, As Naveen mentioned, you can copy the code from the sequencer and paste it in the job control and you can edit that code. What i am trying to say is the job control is only available to normal jobs but not to the sequencer and you can edit the code, which is created as mentioned in my e...

Goto the job properties and select the job control tab. There you find drop down box and 'Add Job' button then select the job from drop down and click on 'Add job' button. This process will create BASIC code to execute the job in sequence. And of course this can be modified.

HTWH.

Regards
Saravanan

Batch job is nothing but the code is written by DS when add a job in the jobcontrol. You can write your BASIC code as well to control the dependency in the ETL process.

HTWH.

Regards
Saravanan