DSXchange

I said a -jobinfo loop. Meaning, in an iterative fashion make a normal dsjob -jobinfo function call until the results say that the job has finished. So a "while" or "do" loop much like you've already posted but just checking the status of the job. Once it has finished, do the cal...

peep wrote:Can i use -run -wait parameters?

No. Either only run the script once the job has completed or make a -jobinfo loop inside the script until it tells you the job is complete then pull the log records.

Start by answering some of the questions asked of you, otherwise we're just guessing what you are seeing. Note that the "tuning techniques" available haven't changed in the 8.x environment, they remain the same as in the previous version.

Why "without using Transformer"? :? You cannot avoid the use of one (nor should you) in a Server job and if you don't add one the engine will. What you do in 8.x is no different than you did in the 7.x world, use the proper string function to get the desired result - off the top of my head...

You have the 'Where Used' tool in the Manager that can help with that provided you have managed your metadata properly. However, I've also gone the route you mentioned but I took advantage of some tools over at Chuck Smith's website to make that easier. After parsing a dsx file, I loaded the output ...

True... specifics around what you are calling "poor performance" would help as well.

They certainly can have one but as noted they don't need one and the first thing to try would be setting that property to "none" as see what happens. I've seen some rather strange things in files over the years including fixed-width files with field delimiters so don't be afraid to try odd...

That's the way the Operator role works in your version, they can only see released jobs which is something people haven't done in years. As Ray noted, you may be able to get close to want you want with permissions.

It would seem your record delimiter is not set correctly, are you certain that it even has one? A fixed-width file doesn't really need one...

First, help us understand your environment. Did you upgrade your 7.5 server to 8.5 and are thus running on the exact same hardware or did you setup a new 8.5 server and import your jobs there? Details are always appreciated.

Then perhaps you shouldn't be attempting to export non-existent jobs. How are you generating the name(s) to export?

DataStage is just a client, it sends the SQL to the database for parsing & execution just like TD SQL Assistance. It doesn't change at all the way SQL works in any database. That being said, I don't have an answer for the behaviour you are seeing. For that, I would suggest involving your TD DBA,...

That's already been noted and corrected three years ago. Not sure what good posting it again does.

Off the top of my head, a userid or password issue?

You'll need a nested pair of conversions to get that string, first StringToDate() and then DateToString(). As Ray noted, you'll need to use the proper format string based on the what the string looks like (or needs to look like) in each function call. If you are still having problems, post the speci...