DSXchange

Hi, We are seeing that a particular job is aborting intermittently when run individually and as well as from Sequencer level. This job is a parallel job running on 12 nodes. When the job is run repeatedly without changing anything it runs fine sometimes and also fails it is very inconsistent. Howev...

Hello pradkumar, As you said Datastage couldn't handle huge data > 200MB . Instead of using XML stage , write the data into a flat file. Use Java/C code to convert into XML file . Using Execute command , implement the code in the Datastage job In 8.x version , we can use Java based stage we are hand...

I have one text file with 3 different layouts. content of the file: the first 5 lines contain header information (layout 1) line 6 to 20 contains detail record information (layout 2) line 21 to the end contain trailer information. (layout 3) how can I read all three formats from the same sequential...

Hello I have a requirement where i will be getting the row such as 1234^;abcdefgh^;bc^;d^;efg^;rghu^;klmn^;bcd each field delimited by ^; Is there a way that i can extract each field by using Field function. I tired using the Field function but it didnt work .Earlier they used the single Field sepa...

Hi, I am reading a sequential file, performing lookup and wrting into a table. In the process I am calling a shared container to do the otherlookups and get values I am getting this warnning main_program: Invalid character(s) ([xA9]) found converting string (code point(s): IBM Confidential, OCO Sou...

hari4dsx wrote:Input field is a decimal (eg. 00012.)..
This is to be converted into integer, with the preceeding zeroes retained.

Does anyone have any solution for this...?


Thanks in advance.

Hari,

Do you want to retain the preceding zero's in the output ?

if so use FMT function of BASIC Transformer

Hello,

I have to parse Spanish Characters in the incoming flat file. We are using RCP with details described in the schema file . Can you please advice how to add NLS properties while describing the String in schema file and the encoding Spanish characters set to used?

Thanks in advance

Hi Craig, Thanks a lot for the documents that you sent and one more thing is that it is working fine for Server jobs,but when it come to parallel jobs we are getting the message which i posted below in the director. XML_Input_1,0: Warning: XML_Input_1: Xalan fatal error (publicId: , systemId: , lin...

Dear Members,

The requirement is to read the parameters defined in file and pass it to the sequence

Can you please suggest a possible solution

Thanks in advance

Hello,

The function is DecimalTostring(Decimal input, "supress_zero")

Before using this function covert your input to Decimal

Thanks

Ragasambath

Hello Monaz, First Set the path of DSEngine , PXEngine and APT_CONFIG_FILE dsjob -run -jobstatus -wait [ -param Parametername=value] $PROJECT $DSJOB The datastage job run based on the project and not based on the folders hi All, Can anyone please guide me how to run DS jobs on command prompt and Uni...

Hello HemaV, XML stage can't handle huge volume of input data and they are not efficient. The workaround is to parse the XML into a txt file using XSLT Parser Such as Xalan or JAXB .you have to design the XSL file to parse the XML Your can read the flat file easily through Sequential file stage We h...