DSXchange

I have a need to eddit the JOBCONTROL.H file to add a mutated version of the DSJobStartTimestamp to my system so that I can get the Timestamp into an acceptiable formate for a Dos Batch file that has to do a rename of a file. The problem is that the original DSJobStartTimestamp outputs dd-mm-yyyy hh...

found it
dsjob -server scrbbususcnc04 -user webi -password 29DmJj13 -run -mode NORMAL Development Load456msg

thanx guys
Jim

OK I found the dsjob.exe file right were you guys said it would be. I have taken the sample code from this post and it errored out saying it didnt understand the switches. This is what my code looks like dsjob -server scrbbususcnc04 -user webi -password 29DmJj13 -mode NORMAL Development Load456msg i...

Wow, am I off base. But it is working now and I have a head ache, so im gona address this later today. Thanx for the input.
Jim

ya thats where i was on my server in the ascential\datastage\engine dir and i typed in dsjob.exe and it told me that it wasnt a good command. Ill try again in the morning.
Jim

when im at a dos prompt, how do I call this? when i put in dsjob even when im in the ascential\datastage\engin folder dos tells me its not a recognized command
Jim

There are no examples of this and its terably confusing to me,
is it:

dsjob -run -mode[reset] -warn 50 Development Load456msg
?
Jim

Thanx the documentation is so masive its daunting at times
Jim

I need to write a dos batch file to call a DS job where in the documentation should I look for that code and an example of it?
Jim

Look in the Index for " [ ] operator ". At its simplest, it is pretty simple - start position and length - so: FIELD1 = "0227" FIELD1[1,2] = "02" FIELD1[3,2] = "27" Yup Yup Yup thats the answer oconv(iconv(DSLink3.TransTime[1,2] : ":" : DSLink3.Tran...

Have you checked the online help? There doesn't seem to be a 'size' portion for time conversions like there is for dates: Conversion Expression Internal Value X = Iconv("02:46", "MT") X = 9960 Conversion Expression External Value X = Oconv(10000, "MT") X = "02:46&...

essaion wrote:I think you have to let at least a blank between MT and the format...
It should look like

Code: Select all

oconv(iconv(DSLink3.TransTime, "MT HM[2,2]"), "MT:HM[2,2]")

, shouldn't it ?

I gave that a go with the same results.
Jim

I changed my code from oconv(iconv(DSLink3.TransTime, "THM[2,2]"), "T:HM[2,2]") to oconv(iconv(DSLink3.TransTime, "MTHM[2,2]"), "MT:HM[2,2]")
and still didnt get any return
Jim

chulett wrote:I don't think there is a "T" conversion code... don't you need to use "MT" to do Time Conversions?

I honestly was going on "IF Date is D than Time is T"

ill give it a go
thanx
Jim

PS it didnt give me an error with T eather

I have a time column which looks like 0814 i need it to look like 08:14 i have tried to use the following code: oconv(iconv(DSLink3.TransTime, "THM[2,2]"), "T:HM[2,2]") I dont get an error nor do I get the any data. It leaves the column null. I am importing it into a sequencial s...