DSXchange

What version are you on, 7.5 has a stored procedure stage. That stage can make your life much easier.

Or you can have a small basic routine, calling the DSExecute() function. You can run your dos command there. Have a routine activity stage call that routine. Connect the routine activity stage to a sequencer. That should work.

Creation of new database means, you need a new odbc connection. Need a handle, bind your database and then DS will be able to connect to it.

Click hereto get a code representation of what Ray explained. Check out Ray's reply in that link i provided.
Regards,

If your stored procedure doesnt have OUT or RETURN parameters then look into the odbc stage. It works pretty good for calling stored procedures.

Seems like someone has been pinning down our good ol friend Craig.
It happens
Jokes apart, thank you so much for doing that, i will definately check it out on ADN.
Cheers,

I agree. When subject matter such as the current topic, is under discussion, folks would like to invent new ways to get something done. There are many ways to do a particular thing but that doesnt necessarily mean that its the right way. I think its an important decision to make for our Premium post...

need to know the job status from the director. Also in your designer, try running it via the keyboard, i think its F9. You can check the shortcut by going to File.
Do all the developers at your end face this issue?

Thats exactly what i was wondering too. I tested out my code too. I knew we were missing some crucial pieces of the info.

This is really strange. HOw come it doesnt work? Try Ken's suggestion, that will most certainly work. Did you try loading the output to a sequential file instead of the table. What is the sql type, length of your target column?

Please do not quote entire messages as it becomes hard to scroll through.
Regards,

Can i ask why you want to do it in a routine? You can use the unix level word count command to get the row count wc -l yourfile If you absolutely have to use it in a routine then just build a small routine Something like cmd = "wc -l ":Arg1 Call DSExecute("UNIX",cmd,output,re...

Step1: scheduling team will enter 3 parameters(Company,entity,datetimestamp) while running the DS job. Step2: we have to capture these papameters and we have to check in UNIX in specific floder(/opt/ibm/data/Projects/WORKSPACE/lnapps/BI/data/) is there any zip file name matching with above parameter...

I have to say, pretty impressive from memory.
I guess this conversation turned for the best for the OP.
Regards,

jshurak wrote:we need them to appear like this: 00000000000028550

The OP doesnt want the decimal point anymore. He just wants to strip it out and fill in leading zeros to honor length of 17. Thats why I put in a R0 and not R2.