DSXchange

Is there any justification to keep this requirement out of datastage ? Does datastage Server edition handle itself well to generating such complex files ?

I would think using JAVA or PERL etc makes more sense. In fact I would prefer they continue this using the COBOL program on the mainframe.

@chulett : If they are writing to an error/ reject target in Server jobs, it would only have an 'input' link .

I could have tried that , but the group for which im doing this activity does not have Parallel jobs licensed . Does the Server CFF stage now support writes ? I mean we are with DS 8.7 Server edition.

Regards
Ramesh

try using this in a command activity stage if you prefer it that way : echo "SELECT NVL(MAX(NUM_ITERATION),0)+1 AS ITE FROM TABLE WHERE DATE = '#PARAMETER#'; " | sqlplus -s user/pwd@dsn | tail -2 | head -1 Use the Command.$Output from the command activity stage and remove the field mark us...

One could always create a re-usable routine using DS ODBC.H , but the one that created stopped working after a while , and moreover always gives a darned license warning error ( Thanks to Data Direct ) - even if its called by a DATASTAGE routine.

Im working on a project for an insurance firm where they want to use Datastage to generate a Multi Format Flat File . Currently this is being done programatically on a Mainframe platform [ using COBOL of course :P ] but they want to now source the data from an Open systems Oracle DB and create the s...

Thanks Ray . I will make note of that - the need shall soon arise .

One problem I see with the famous 'Code tags ' is that they are related to the Font type - Courier New , So when i have a different plain text font in my browser - like consolas or lucida typewriter , they dont show up as plaintext . So the webmaster or site manager needs to make sure code tags disp...

Can I emulate behavior of a sequence funnel using a server link collector so that input link data streams are ordered in a predefined sequence- I dont see a sequence or ordered collection algortithm , and sort-merge in link collector has its problems/bugs [darn:]? If not , Is there a way using a has...

Although a Parallel routine written in C will generally work just fine , it is recommended that you write routines in CPlusPlus(C++) and compile them as such.

Try awk based unix script . This awk script will work even if your source file has an arbitrary number of columns ( you currently have 2 delimited by what i think is a space character) awk -F" " '{for (f = 1; f <= NF; f++) a[NR, f] = $f} NF > nf { nf = NF } END { for (f = 1; f <= nf; f++) ...

If you havent uninstalled your client , can you try right clicking on your stage and selecting 'Properties' - > it may open up .

is the pattern '*' found in the data also ? Otherwise you can define this character as the record delimiter.

DSODB is the directory for Operations Console.
The log files starting with handler may be indicating that the connectionf rom Engine Tier to OPCON database may be having frequent issues.

There are some bug fixes for the ASB pack in Fix pack 2 , are any of them relevant ?

JR43541
JR33738

Thanks
Ramesh