DSXchange

I am reading XML using the XML Input Stage. I get six rows but I do not get six unique rows. Only the first unique row gets the values. When the repetition element repeats, the values output reflect the first occurrence of the repeating element values. I have a solution that appears to work. I ended...

1. Only a single XPATH can be chosen as the repetitive element. 2. The example below results in only "first" values for each combination of ColA, ColB, ColC. In other words, ColA OR ColB OR ColC must be chosen as the repetitive element, not all three. In reality, it IS the three together t...

It is now possible. There is a patch from IBM. I just tested it and it appears to work.

Fast export, Multi-load and API too

NAME2:String[100] = substring[1,100] (NAME1)

Make them VARCHARs (string[max=]) not CHARs (string[])
therefore

NAME2:String[max=100] = substring[1,100] (NAME1)

I can name that tune in a fewer notes but it might be too unmaintainable. Use ExecSH in the Before-job subroutine. Input Value: echo `date` >> #InputFile# (and whatever other formatting is needed to make this line look like a input line in the file). Interrogate for this line in the job transformer ...

There is an E-case and patch from IBM. I apologize for not having the specifics on it.

Yes at Runtime
NO at Design time.

The config file defined by $PROJDEF will not be available in Designer but the job will run. Therefore unless you need the functionality in the GUI to define pools, restrict stages to a node, etc. then $PROJDEF will work in the job just fine.

Gotcha. I went to the documentation; page 33 of xmLPACK_20_Designer.pdf Mapping Transformation Errors to DataStage Errors The XML parser reports three types of conditions: fatal, error, and warning. �� Fatal errors are thrown when the XML is not well-formed. FATAL means stop. I...

Well, the first thing you should do is get well formed XML. Can the XML above be parsed by, say IE? I think not. At the very least the start tag <FrdSupplierData> has got to have one of these End tag thingys; </FrdSupplierData> I don't think Xalan can do anything with input that is not well-formed e...

None that I know of but would love to be proved wrong. You posted in the Server forum and so the reply you got was Server-centric. Help a brother out and post in the right forum and you'll probably get a more appropriate answer.

Go to Manager, navigate to the Stage type you want, highlight it in the right hand window and select Usage Analysis from the Tools Menu. This will give you every job that uses the Stage type.

The External Source stage WILL work. Go to Ernie's blog and search for it.
http://dsrealtime.wordpress.com/category/xml/

Chulett

Not sure why that would be a problem. Besides, if you don't add it, DataStage will.

I don't think that is the case. I think the XMLInput, an Active stage, will not put an "IDENT" Transformer between it and the Folder stage.

Are you sure Datastage will add it?

Why do you have a Transformer stage between the Folder stage and the XMLInput Stage? I would think it should be Folder Stage and then XMLInput.