DSXchange

Portion of the schema shown below. There are many inputs to the XML stage. I joined all the links successfuly using HJOIN function(Key is Policy_Number). I could map the Roles group through Hjoin with Main input link. Coverage is a subgroup of Roles. I could not map this. I am not able to find where...

I have created a parallel job with a XML output( latest in Version 8.5). I have shown here the level and type of XML join I used . The question here is what type of XML function I need to use to achieve multiple level complex group. ROLES are unbounded element. COVERAGE is also unbounded. For every ...

The sequential files had level number. Sequential files are Mainframe files had level numbers which where imported through Copy book. The level numbers were propagated through out the job. When I removed the level numbers, the error message vanished.

I have a job which reads 6 big seq files , joins , pivots and lookup and then loads to a XML file. While running the job, I get this below error. buffer(14),0: Fatal Error: Caught ORCHESTRATE exception in player process: APT_BadAlloc: Heap allocation failed. What is the cause and solution of this er...

When I run the parallel job , the job aborts with a fatal error main_program: Syntax error: Error in "leftouterjoin" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in binding: Could not find type: "subrec", line 5391 Could not lo...

You mean say that the efficient way is to write a UNIX shell script and execute through DataStage

I have a requirement to Unzip multiple files in a directory. files can be of the type PDF or JPEG or txt or csv. The count of files in a directory on daily basis may vary and also size of the files may be huge ( hold million of records). Which is best to use Datastage or Unix Shell script ? need exp...

Can anyone explain me the what the below DOS subroutine does?


In Before Job subroutine : EXECDOS

for %I in (D:\APPDATA\VAS\IN\tmcad.txt) do if %~zI==0 (exit 1) else exit 0

I need to convert the date in the parallel job version 8.5.

Input format : AUGUST 09, 2008
Output format : 2008-08-09

Is there any function to convert this date. Please help.

Thanks for the input. Closing the post as resolved.

what are the ways to acheive this ? Could you please explain in detail.

source column is a decimal data type of (7,2).

Data in source :

123.34
3456.45
12.45
8.1

Question is: what is the funtion that I can use to extract the scale part of the decimal

as in source



123.34 --> 34
3456.45 --> 45
12.45 --> 45
8.1 --> 1

Is it possible to create a single fixed width sequential file from different data layouts?

the data layout are as :
Header record ( 1 record)
Detail records ( multiple records)
trailer record ( 1 record)

As per Rays suggestion to get the command to work, Where can I find the full pathname of the sqlcmd or how to set the path environment variable ?

Thanks for your reply. I tried to execute the command sqlcmd -S servername -U userid -P pwd delete from DatabaseA.TablenameA; it throws a error: 'sqlcmd' is not recognized as an internal or external command,operable program or batch file. My reqt is : Query a table A in Database A and load to table ...