Datastage Basic WriteSeq

nag0143 · Post by **nag0143** » Tue Nov 09, 2004 4:37 pm

Thanks All For your Suggestions, Starting with i have no idea how you can do in Basic,Now i have couple of options to try my solution..

Thanks All

kcbland · Post by **kcbland** » Tue Nov 09, 2004 7:15 pm

The point is always use WEOFSEQ will be required if you are opening an existing file. If you fail to use it, you could potentially have a "merged" effect of what you just wrote with what already existed in the file. This is absolutely an issue if you write fewer characters to the file than what currently exists.

The question is whether you do it right after opening an exisitng file for writing, or after you're finished. Unless we get a definitive answer as to the flavour (

for Ray) of the engine, you're probably better off using WEOFSEQ per Mike and Craigs recommendation, which is right after opening for update.

I'm leaving my code as it is, I'm pretty sure I tested this and wrote the appropriate logic for DS. But I have been known to be wrong...

mleroux · Post by **mleroux** » Wed Nov 10, 2004 6:26 am

Being one to do things the blunderingly ignorant way at times, what about just using cat and a pre-created text file with the headings?

Code: Select all

cat HeadingRow.txt SingleDataRow.txt > Output.txt; rm SingleDataRow.txt

chulett · Post by **chulett** » Wed Nov 10, 2004 7:58 am

Morney, that was mentioned earlier in the thread. However, the question posted was specifically how to do this in BASIC, hence this long and winding road...

mleroux · Post by **mleroux** » Thu Nov 11, 2004 4:51 am

A thousand apologies, effendi.

*** LAME JOKE ALERT *** That's what happens when trying to scan through threads very quickly when hyper-threading is not enabled.

chulett · Post by **chulett** » Thu Nov 11, 2004 8:21 am

No worries. I know how that happens, especially with these multi-page wonders where you miss something from an earlier page. :D