DSXchange

Hi, I have a server job which fetches data from a DB2 table based on the Flag value & inserts into another DB2 table. Also, one field (flag) in the source table is updated as and when data is loaded to the target DB2 table. Db2 table (X) ---> Transformer -----> Db2 table (Y) & Db2 table upda...

No DBA is killing the session. The job is aborting the 1st time due to the error & on manual start again, its running fine. The time gap between the start & the abort is approx 30-35min. Sometimes its even an hour. Not sure what is happening in that time frame as we don't have access to moni...

But any clue of why the job is running successfully the second time ? And whats the actual cause of this error.

Hi, When I run the server job 1st time, I get the following error: Communication link failure. SQLSTATE=40003 SQLSetStmtAttr: Failed to set row array size statement attribute for prefetch. [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 SQLAllocHandle: Failed to allocate environment ...

Thanks.

Can you plz let me know which is the best way to do it ?

Regards,
dxk9

Hi,

I want to call the job parameter (age) in the where clause of the SQL file called in the DB2 stage.

The clause used in the sql file is :

'where Cust_Age = '#age#'

But its not recognizing the parameter.

Kindly help.

Regards,
dxk9

Hi,

I am not able to call DSSendMail directly in the transformer. Can you please let me know the routine to call the DSSendMail.


Thanks,
dxk9

Thanks for the clarification.

I will try DSSendMail routine in place of UtilityRunJob.


Thanks,
dxk

Thanks qt_ky. It worked !!! Can you please help me how to use UtilityRunJob to call DSSendMail directly. For eg., If I want to send a mail to xyz@gmail.com and the contents should be 'We don't have any records'. I searched the forum, but couldn't find the way to call DSSendMail via UtilityRunJob. Th...

Thanks. I will try that logic. I tried the 'UtilityRunJob' utility, I am stuck with the %ParamsAssignments% of the syntax. Syntax : UtilityRunJob(%JobName%, %ParamsAssignments%, %RowLimit%, %WarnLimit%) The job which UtilityRunJob is calling has 4 parameters & all are assigned values using Envir...

qt_ky,

Thanks for that clarification.

Now, I have a job which fetches the count & stores it into a file (say Record_Count.txt) . Now can you tell me the flow of different properties of Execute Command activity.

Thanks,
dxk9

There was some DS issues and my execute command job got corrupted along with few other jobs. I tried to run the SQL 'Select count(*) from Table_name' in the Command & in the triggers, I had given two flows based on the return value. Can you please let me know the Syntax for 'Command' in Execute ...

Hi,

Thanks all of you for the response.

I will try the 'UtilityRunJob' and post my comments.

Chulett,

I tried using Execute Command Stage, but its not working cause of some syntax issues.

Can you plz help me on the syntax of the 'command' & also the 'custome trigger expression'.

Thanks,
dxk9

Pandeesh,

I should use FTP stage in Datastage to FTP the file. My back-end is DB2. Can you please suggest for the above requirement.

Its something like, I want to implement the 'if..else' clause using datastage server sequence.

Regards,
dxk9

Hi, I have a requirement which has two conditions. a. If the record count of the table is zero, then I have to send a mail. b. If the record count of the table is > 0, then I have to FTP a file to the clients. Query: I have developed a job which fetches the count of the table and stores it to a file...