DSXchange

did antbody tried this

OR

know the solution!


thanks
--Sunil

dscmdexport exports whole project not an individual job!

dscmdexport exports whole project not an individual job!

Hi Brigitta, I dont have the stage installed hence cant provide you the demo job, but as far as i remenber you dont have to give a description for the message (just define the data type and its size). Moreover, are you reading from the MQ or you are writing to the MQ? Also it will be good to go thro...

why dont you try creating a befor job subroutine.
code tthe subroutine to check the size of the file, if the size is zero then send mail, and use it as a befor job subroutine in your job!

thanks
sunil

why dont you try creating a befor job subroutine.
code tthe subroutine to check the size of the file, if the size is zero then send mail, and use it as a befor job subroutine in your job!

thanks
sunil

you get 2 colums out of MQ!
1. Invocation ID
2. message!

the message is a whole long stream of message (say 25000 char long). You need to parse that message using some logic. What i have used is a XML stage to parse it and get the data in required format!

try it!

thanks
suunil

Using the datastage client utilities we can export the jobs. dsexport.exe provides option for design or executable for a job. When exporting the whole project using dsexport if we use a switch /exec /append, the command fails? :shock: (it works for exporting individual job) can you tell me that when...

Just curious as to why you need to run the sql query from the Dos prompt. If you can describe why you need to do it that way, there may be another solution. It is a little program written by me in VB. They may post source code for something like this in a members only area. If that would be somethi...

It is a little program written by me in VB. They may post source code for something like this in a members only area. If that would be something you might want then ask Dennis the Editor. Thanks for help KIM! i need that code, to understand how that works!if you can provide a way out then it will b...

Well, thanks for all you comment! i can use manager and select all those tabs and check boxes as told by you. But the need is i need some command (as dsexport) to export a routine on the client machine. On top i need only that routine to be exported. I have dne this for job (can export individual jo...

kduke wrote:Do a search for Dwn_ExecTCL.exe.

KIM,
Is this a utility coded by you or its a datastage product utility and comes with a standaed package?

thanks!

DSguru2B wrote:I did not get your question. You are having trouble exporting or importing a single routine?

I want to import a routine as a single commodity not as part of whole project!

Here goes one more stuff. We can write various sql's and run them in routine using "EXECUTE", but is there a way to run the same command (TCL) at dos prompt by any means? I gave a thought to this and can think of following options: 1. Write a routine and execute it from DOS Prompt (cant fi...

Hello!
I am stuck up wth a abnormal stuff. I am exporting all jobs (as individual dsx). It goes pretty good. but when i gave thought to import a routinr in same fashion, guess what . Gone through a lot of mails but no luck.

Anybody has any clue to this?