DSXchange

Its here

Wont the OP be better off doing this in a shell script? Wont it be faster? Right now she is reading each line one by one and DSParams file is not a small file.

chulett wrote:Just run the job. If the file isn't there, the job will abort without you having to do anything.

There you go, its as simple as that
Dont abort the job, end it gracefully as others have noted.

You can use DRS stage and write a the delete statement in the before sql tab.
When you say "first delete and then insert", an option already exists for it. Is this a selective delete. Give more info on the delete 'where predicate'.

I posted a script a while back to do exactly what you want. Search for it. Its a small script and will get your work done with less work and back ache.

madhukar wrote:But i have to do it in datatsage and ....

You have several solutions now. Pick your choice. Get as far as you can and if you have any problems, come back with what you have done and whats not working.

awk will definately do the trick. You can also write a C routine which takes in your three columns and returns the generated rows.

Do different levels of search on key words like "memory estimate" or "scratch space estimate". This has been discussed before.

Hereis a similar post.

Get yourself a compiler. Or if its there get it setup. Transformer should work fine then.

If you have to go with OS then use awk. awk can get this done.

What compiler do you have? aCC or gCC? Check the compiling options in APT_COMPILEROPT. Try them and they should get your C program compiled.

537 columns huh? The error says 539. Ray might have hit the bulls eye. I wonder if that number 539 in the error has a meaning, like number of columns present or something.

The C function will return a character field. YOu need to change it to timestamp using StringToTimestamp(). I tested the whole nine yards here at my end and its working like a charm. I wonder what you are doing wrong Did you populate the results to a flat file first and inspected the file? Once you ...

And well worth it. The entire routine is right there.