DSXchange

Hi, I have a multi-instance parallel sequencer invoking a multi-instance server job. The seqencer is receving a value in 'pJobName' job parameter as ABC.123 (some jobname.Runid) We are passing this pJobName value to server job as the invocation id. But the job gets triggered with name as 'ServerJobN...

Hi, I have a parallel job on 8.5 using Teradata connector stages where I have to read the batch table, and then update the same batch table. The flow is like TD (Read batch table)------>Transformer --------> TD (update same Batch table) Will there be any risk with such design? like table getting loc...

use format as "%dd/%mmm/%2000yy"

Hi,

I have data in input as 20/Sep/03. When i try to convert this to date using String to Date function with %dd/%mmm/%yy format it is converting the date as 1903-09-20

But I need 2003-09-20.

What additional things do I need to do to convert the dates to 21st century dates instead of 20th?

Thanks

Hi, I am working on DS 7.5.1 version. We have a parallel job to truncate data from a teradata table, for this we are using "Teradata Enterprise" stage. The job runs fine in Dev box (reads from a file and truncates the table). When we moved the code to test box it is failing with following ...

Hi I am writing a custom query in my MLoad stage to load table 1. The 'After' script of Mload stage has another INSERT statement to load some data into table 2. I cant chage this flow. The After script job sometimes gives me following error BUT THE JOB "DOESNT" ABORT. **** 14:41:55 UTY1008...

I am using custom script in MLoad stage to load the table and also I have to define the fileds in MLoad as Varbinary. But the moment I define the fields in MLoad stage as varbinary, it changes the datatype in the previous stage also, and that is remove duplicate stage. And the job fails as its not a...

Hi, I am using DS 7.5.1a version. I have a teradata table defined with all fields as VARBYTE(32) as the info to be contained needs to be encrypted. How can I convert varchar and date datatypes from my XML file to Varbyte(32). I dont see conversion function for this in datastage. Please help. Thanks

Hi, I have a parallel job which generates output in an Sequential File with fileds say A, B, C and D The volume in the file can go upto 1 million. I need the data to be sorted on C and D when the file is created by the job. Will selecting the SORT MERGE option in the Partitioning tab of File stage, ...

Hi, I have to write an after job subroutine to send emails with attachments. DSSendMail can take care of this but my code is on Windows platform. Hence could someone please tell what are the prerequisites required to send emails from datastage when on windows platform (like configuring any SMTP serv...

Hi, We have a Sequencer with a Rotine Activity stage to call a routine. The compilation of sequencer is failing (although the routine has compiled successfully) The compile report says Error compiling Job Control Subroutine ABCD123 Compiling: Source = 'RT_BP356/JOB.1085833124.DT.1480941133', Object ...

Hi, We are trying to collect statistics in the M-Load stage by calling the procedure (which takes the DB Name and the Table name as parameters) CALL QLFR.COLLECT_STATS('DBName','TableName'); But the job is getting aborted saying **** 15:23:13 UTY1014 Unsupported RDBMS/SQL statement: "CALL"...

Hi, I am parsing an XML file using the XML Input stage and reading the file through an external source stage. The XML gets parsed according to the xpaths I have given. But I want the Job to abort in case there is any error in the XML format e.g. the closing tags are missing for a tag which we are tr...

Thx Ernie....

Yeah it was a very minor problem with the xpaths. Works fine now.

Thanks
roy

Hi, I have to parse multiple XML files named as replyfile*.xml (using wildcard as the files have a datetime stamp in the name). I tried 2 designs 1. External Source Stage -----> XML Input stage ------> SEQL file and gave following command in external source stage: ls /directory/replyfile*.xml Althou...