DSXchange

Hi Rao, Iam getting an error like this when I used your logic APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Inval...

There is another type of trigger that could be handy: The "Otherwise" trigger.
Instead of the 3 triggers,

You could run a "Failed" and an "Otherwise" trigger. from JobActivity1.

IHTH,

Found the link:

<a href="http://www.ascentialsoftware.com/servic ... >Operators Ref</a>

Functions to be used with Transformers are listed( i mean it literally.. no detailed descriptions or examples) in the Parallel Job Developers Guide in Appendix B(Page 1092). Function to be used with the Modify Stage are not present anywhere in the DataStage Documentation. The ones that are listed to...

Hi Chris, That info is buried deep in the guide in Appendix B(page 1091 of 1130). The examples and complete descriptions are non-existent but atleast you have a list of supported arguments and return values. It's not very good but thats all there is(Best way is to build a small test job and figure o...

Hi Ratan,
If you ned to generate a Timestamp from DATE and TIME fields, Read up on the
Function on Page 1092 of the Parallel Job Developers Guide.

IHTH

Hi Usha, The Sequential File Stage supports Reading both a Single file and multiple files (Given a file pattern). Property to look for is: Read Method, specify whether to read specific files (the default) or all files whose name fits a pattern. Parjdev.pdf Page 144 The Caveat here is that all files ...

What do you mean by "sequential sort"? What i meant was that the Sort stage can work in both sequential mode and parallel Mode. while the on-link sort, as it has to work on partitioned data, can't. I dont recollect if on-link sorting is available on the Input of stages running in Sequenti...

2 more:
1 For large data set sizes (>20 MB) the Sort Stage is better.

2 <:?: >I dont believe the On-Link Sort can do a sequential sort.. </:?: >

kumar_s wrote: Yes it is often difficult to get these in right position.

Good Ol' Notepad (Font:Courier) is my preferred Canvas. The rest is just copy and Paste.

I was going through the Plug-in Documentation of the Row Splitter Stage and found that it has a capability of generating the desired splitting up of multi-value columns into seperate rows. I could not try this.. (No access to DataStage). but the way to go would be Src---------->Transformer------->Ro...

Hi Om,

Wrap Kumar's Function call in ereplace like:
to replace all spaces to Empty Strings.

Try This: JanOnlyHashedFile | | | |[RefLink] | Jan&FebSrcFile--------> Transformer------------------------------------>Output1 | |[Only Feb Constraint: IsNull(<RefLink>.<AnyColumn>)] |-------------------------------------------->Output2 Output 1 Will have All Account Numbers. Output 2 will have ...

Hi, Please refer to this Link: <a href="http://dsxchange.com/viewtopic.php?t=93374&highlight=bapi+return+table&sid=5f3c0c188320dac8b59ea5114f39fa6a"> LINK</a> Basically If the BAPI is being used for Input the return table parameter(which is usually an output parameter) is treated b...

But I'm checking for this qualification using the stage variables. I should have the run the job and checked the output. Anyways, Do you think that this design will fail?? Thanks, Naveen. Hi Naveen, The issue with this is that multiple columns per row need to be translated using the reference table...