DSXchange

Do one thing In transformer stage use stage varables to generate new records and add that to existing record and seperate the records by newline char.

I think row generation can be done using routine.Either use parallel routine or use the server job for this and write a basic routine for that.

You can use RunTime Column propogation method for this.
But you first need to seperate metadata and records then from metadata create record schema file and in the dataset use this record schema file.

Hi,

We have installed Datastage server with RTI agent and also RTI server,client and RTI console application.But even the web services enabled job option is not enabled and web services table definition in import table definition tab is also disabled.

Thanks in advance

chulett wrote:Out of curiousity, have you been through the XMLPACK_20_Designer.pdf document? It goes over using the XML Output stage (and the others) in decent detail. ...

Hi,
I have gone through that document.But I couldn't find any example nor complete relevant details or may be i am not able to grasp fully.

Hi, Are you writing to the XML output stage?. In the columns /Description , give the Xpaths and also sort the data before writing to the XML file. That I know,we have to give xml description.Normally we are able to repeat one element. If we want to repeat then we can generate those tags seperately ...

Hi, I have to generate the multiple repeating child elements(A,B,C) under one parent tag(D) which itself is child of another element (E). So in this Case structure is like E | D- | | | desc columns | | | A | | | A | | | B | | | B | | | C | | | C | | | C | D- | | | desc columns | | | A | | | A | | | ...

daniel0623 wrote:add NLS_LANG in your dsenv.Make sure its value is same as db.

can you please elaborate more.

hi all, I am getting the following warning An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG In NLS map i have checked <ISO-8859-1> this value is there and in unix level parameter w...

Sorry ray,

Hi all. I am doing sum of columns decimal(15,2) But i am getting warning AG_GLData,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal. For that i have tried changing target length to decimal(17,2) also dec...

Hi ray,

I am new to DataStage PX.I have checked in PDF provided with installation.But i couldn't find the description of orchestrate operator.

Can you please help me to get that.If there is any online installation.Please send the link

Thanks,
Anuj

Hi,

You can do this in before/after job job subroutine.

Hi,

I am new to datastage.I have seen that they are various utilities available under orchestrate.

Can you tell me where i can find online documentation related to PX which you are talking and the Orchestrate manuals .

thanks in advance,
Anuj

Can anyone pls explain How to get the current timezone of system using that TZ unix env variables as i am not aware of that.

Pls explain in little detail how to get that in PX job.

Thanks,
Anuj