DSXchange

Other alternative to pass the parameter from the file. Use Execute command activity to read the file using 'head' as the command and -#StartLoop_Activity.$Counter# | tail -1 as the parameter to it. and pass the outpu of this activity to the subsequent job through Command output. Place these arrangem...

The same can also be acheived by Before Job subroutine.
/path/ls -1 > {File Name}
And use this {File Name} in your input stages.
ls -1 would give you less work than ls -l.

MaheshKumar Sugunaraj wrote:Apologies for Posting twice.

Regards
Mahesh

You could have deleted the second one

Well, this had me stumped for a while, but a clever colleague here pointed out my mistake: I was using the wrong "Read Method"; I was using a method of "Table", which does not work when reading a view. Humm.... View is also considired similar to tables in DB2, you can find an entry for view in SYSC...

rasi wrote:Iconv and Oconv won't work in Parallel Stages you need to use DatetoString function. Read the manual for more help on these functions. Or post what is your syntax.

Shouldnt it be StringToDate

The whole post is getting colorfull... Not only because of the involvement of various posters and their thoughts but also due to the whole bunch of Smilies used

Hey Kumar , Thanks a lot , u r really gr8 . When I turned off RCP on project as well as job level , it did not work , I still got warnings , but when I turned it on at project level and turned it off at job level it worked , no more warnings due to change capture stage , thanks a lot Thats great. D...

I hope the multiple transformer is not confused with Basic Transformer and PX Transformer.
I hope you also aware of the option to customize you pallet. Right click on the pallet and click on Customization Pallet.
Where in you can see list of all available icons.

It bases the key column change based upon what you are telling it to srot, not the keys that you have declared in your metadata on the columns. To get the effect that you are lloking for, you should have to sort stages back to back. The first one sorts all three columns. The second one has the two ...

Hi, Pls post the Generated OSH code. You can have one more try, may be dirty. Re map/remove all the column/links. Click ok ot come out of the stages. Now just dont drag and drop the links but Try to type in the Output column name and datatype and make a auto match or manually drag it. And to clear t...

As an administrator setting, 'under Operator specific' an option called DSIPC_OPEN_TIMEOUT is available, which by default it might be 30. This can be increased to 300 - 600. But, apparently you need to nail down the cause of the time out. If it is really the lack of resource, it may not be advisable...

[quote="Thibal"] If Mr Wurlod uses Job Sequences, it can't be bad quote] BTW, nothing like 'BAD' in DataStage, where IBM/Ascential might have purposefully introduced in their own produce. Its all about how effeciently we use the available option to acheive the task in an easiest way. Obvio...

UNIX - AIX.
But i was under the impression that, Decimal is also similar to integer which doesnt hold NULL rather 0s in it.

Check Field default in Format Tab. The Quotes might be double. Place it Null if you require or just remove the option.

I guess, the extendable property of TimeStamps 'MicroSecond' can be enabled to sort this issue out. Else why can the project level of the timestamp in datastage be changed to the required timestamp with micro second.