DSXchange

ray.wurlod wrote:Can you post your design? Wrap it in code tags, and use Preview until you get it looking comprehensible.

Or do an Exact search on this forum for the term imageshack - you'll find a way to post an actual screen print of your job design.

Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM. In addition to the other advice, note that the Director only shows schedule information if the jobs have been scheduled by whomever you are currently logged in as. If you have multiple userids s...

You would actually have to specify three fields on the Columns tab, of which the first two would be marked as Key fields and then return all three in your sql:


Something along those lines.

As do I and it works fine for me - and I assumed that dev was one of your project names, is it?

If you need to, try it with the server / userid / password keywords as well.

There's no -project, it's -ljobs and if you are on the same box as the server it's even easier:


If you issue the command without arguments, it will dump out a normal 'usage' type message.

Look at the source of the routine. Check the online help for the System Variables in particular the definition of @TRUE and @FALSE.

The same series of steps you would have to do if you were telnet'ing into the box after the ftp and changing the permissions yourself.

ray.wurlod wrote:I'd love to help you out. Which way did you come in?

And you thought *I* posted some groaners.

What version of DataStage? I was under the impression that the 'latest' version had support for more than just Oracle... or is that still coming RSN?

Well... perhaps a post in the FAQ Discussion forum? See if a legitimate list of things can be generated and then perhaps a FAQ could come out of it.

Are you sure it's not the first record? And is there anything... different... about this missing record?

As long as the remote server allows it, there are the 'Telnet before' and 'Telnet after' commands available inside the FTP stage. Setup the 'after' session to log in and issue the chmod command.

The Director logs are not files they are hashed files in the project - RT_LOGnnn where nnn is the job number of the job being logged. Search the forum, this has been discussed a bazillion times. There are routines to get the information, you can do it from the command line with 'dsjob', etc. Kim Duk...

1. Agree. Sleep != Hang. Post your system specifics - operating system and number of CPUs primarily. RAM too if you know.

The field will be populated based on the setting of the Missing Columns Action on the Format tab. By default, it gets mapped to a NULL, I do believe. Check the online help available from within the stage.