DSXchange

You need a before routine probably. * Call routine like #InFileParam#-#OutFileParam# InFileName = field(Arg1, '-', 1) OutFileName = field(Arg1, '-', 2) Cmd = 'SH -c "':"perl -pe 's/[\x00-\x09\x0B-\x1F]/ /g' < input > output":'"' execute Cmd capturing output return...

Ray

Why not use ls command.

Another option is Reporting Assistant.

You need the routine posted on ADN http://developernet.ascential.com/forum ... php?t=1043.

Thanks guys. Ray, Will Rogers said "I never met a man I did not like until I talked to him". They usually just quote the first part. Makes a difference when you add "until I talked to him". I like your quote.

Ray or Hester or someone: There is a way to reset and job and remained attached to it but I am not sure of the syntax. This is a multiple instance job that I want to reset and run. I was just deleting the RT_STATUS records and noticed this did not always work. I changed it to this code below. If you...

We use an 8i client to update 9i tables. I have not tried a 9i client with 8i tables but I expect it to work. For testing purposes I would like to know that you could use 2 different clients with separate projects the way Eric describes. Post your solution and explain how well it works when you are ...

You need to do it in a before job routine. So it would need to pass in an argument which would tell it to truncate the table or not. This should be controled by a parameter. Pretty simple routine. I would put the sql to run in a text file and use sqlplus in a shell script to execute. Ray and others ...

There are several. You could use a shell script which does an exit 0 or exit 1 when it fails. You would need to do more error checking. You could do an openseq in BASIC. The status command will give you the size of the sequential file. Do a search Ray and others have posted code on the status command.

Usually DataStage will use up all the resources. The other application may not function with DataStage on it. If the other application is a database then you may gain performance if it is your target. Cuts down on network traffic. Usually reporting is not going on during loads so this does seem to w...

God is love. Love is demonstrated by mercy, gentleness, meekness and kindness. Mercy is the powerful being gentle to the powerless. God is not mocked you will reap what you sow. If you sow mercy then you will reap mercy. Mercy is such a rare thing. I think all of us are motivated by something more t...

Ascential How long will you play the bully? What damage could a book from Ray do? All he wants to do is make us better DataStage developers. What damage could Ken Bland's white papers do? You are a billion dollar company. You can enforce your will on any of us. Someday all of us as individuals are p...

TNS needs to be resolved with sqlplus. If you get on the server and use sqlplus from there and it works then it should work in DataStage. If not then your Oracle home variable is wrong or one of the other Oracle variables.

Nice signature Craig.