DSXchange

The DataStage engine is on the server. If you have a programming backgroud then on a higher level of understanding, compiler/interpreter is to programming language as DataStage engine is to Datastage. It does a lot more, has all the internal repository tables, can run uv commands on it etc etc etc.

If you know how to code in C/C++ then it should be a piece of cake for your. You just need to code functions. Test it out on command line. Then link it to datastage by creating a parallel routine and providing the object file's path. Search will reveal all.

Its in the database stage. Syntax will be the same as you would use in your favourite sql tool. OPEN command will run only once when the connection to the database opens, before the main sql. You just need to drop index <<index_name>> on <<table_name>> . Search in google for the exact syntax for you...

Do an all term search on key words 'scratch space clean up'.

Unload your table into a flat file or dataset and then do your transformations and loading.

Aww, look what you guys did, Kim changed his logo color again....

dsedi wrote:
transformer I should not use..

And who lay that limit and why? If you have something, use it. Dont tell me your not using it because its slow. What version of DS are you on?

Well its hard to tell if the error is random. Next time the job aborts try resetting the job to see if you get any "From previous run..." messages. Use generated sql instead of user defined. Thats the best I can give you as of yet.

Yes, thankyou so much for creating this beauty. This website has depths and depths of knowledge for everyone to benefit from. If it were'nt for this website, we could not have learn't from our true gurus. Thankyou once again.

Hi DSGuru, Will I get detailed information regarding those files in a PDF for DataStage Administrator / Parjdev / advpx ? videsh77, It won't get more detailed than what Ray has provided. A very precise, to the point answer. He was kind enough to describe some other config files like uvodbc.config a...

WAN's will be slower than LAN's. Thats a limitation from your WAN service provider. Can you watch streaming videos without any pause in them?

rhaddur wrote:
any how where you suggest to add another transformation.
my job work
sorc_file--------XFM------Target files

Two Transformers next to each other. If you want, now you can even split the load in between two transformers. Let both of them take equal load.

kumar_s wrote:DSguru2B is right. '%' is working, contradictorily '*' is not working.

Thanks for the confirmations Kumar. And I thought my system had a bug

.....or even a Modify stage? Datatype conversions can also be made in a modify stage. And who told you that you need to write a buildop for that

Please do. I might be interested in getting your transition document. I seems to be very diverse and complete.