DSXchange

Ha Ha Ha. Three Ha's from me
THis is more like, GettingMyWorkDoneNoMatterWhatXchange. How about that ?

Lets think outside of DataStage shall we. You can do this via a unix script. Here is what i can offer #!/usr/bin/ksh export filepath=/Data/SFDCDEV/scripts/dsx.txt export tempFile=/Data/SFDCDEV/scripts/my.tmp export newFileDir=/Data/SFDCDEV/scripts cat $filepath | sort | awk -F"\ " '{p...

As for fmartinsferreira, you can use

to sleep for 30 minutes.

I think the two sleep syntaxes that Ray is referring to is Sleep n where n is the number of seconds and the other one that he mentioned. But i am not sure about the syntax of SLEEP HH:MM. I am trying to test it but no matter what i put in HH or MM , for some reasons it just sleeps for that amount of...

chulett wrote:You'd have to write your own routine to use the various 'DSGetLog' functions to retrieve just the latest information from the log.

Look at Craig's reply again. He mentioned DSGetLog() function. Read about it in DS help. You will also be able to find many examples here on dsxchange.

Reiteration.....reiteration.....reiteration.... [yawn] and reiteration.

You must be having other warning messages along with that. It will also show you the record in one of the warning messages. You can look at that record, get the key and analyse that record in the source/lookup to identify the culprit column.

Why cant you pass it as a job parameter? I highly doubt that you can retrieve a stage variable as a table name within a database stage. What you could do is do you manipulation in one job and when you know what the table name is going to be, pass that as a parameter to the second job, where you will...

Yea your right, but do we have a SLEEP in Basice. Excuse my ignorance.

You can write a c function. Use the time.h library. It has time structs that can get your work done. You can also do string manipulation within C. Read it like sscanf("%4d-%2d-%2 %2:%2:%2.%6d", &yr, &mo, &dy, &hh, &mm, &ss, &nn) You can do the same for t...

Make the job sequence restartable by going to the job properties and checking the box that says something to the effect, "Add checkpoints..."

Well, if you are done with the parsing the string within DataStage then whats the point of doing it via a script. If you insist, then do the manipulation and write it to a file and then you can read that file within DataStage.

if memory serves me right you would use the 'NAP' command inside the routine. And the NAP will put the routine to sleep for milliseconds.

That is not the correct syntax and hence your quest. But as pointed out, you can get syntax like these from DS help.

As i said, cat them together with a hyphen or a comma and extract them when assigning values to the parameters of job_activity_stage. Say for eg your output looks like this remotePathName;remoteFilename Inside the jobactivity, where you specify the defaults for paramters, do this Remote File Path ==...