DSXchange

ODBC?

And it doesn't really make much sense to use it in a Transformer... after job, perhaps but not typically while a job runs.

The answer to your question depends on where your logs are stored - in XMETA or the 'legacy' Universe repository... which is controlled by your RTLogging & ORLogging settings off the top of my head.

What version are you running?

There is a complete list here, they're over on the left-hand side in alphabetical order: http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.serverjob.dev.doc/topics/r_dsvjbref_Conversion_Codes.html The forum software doesn't like that URL so you'll need to copy/past...

You could have just said the get was for testing only. Everything else we already know.

ps. This isn't Twitter.

I'm also curious why your original script has a 'put' and your new script has a 'get'.

Yes... exactly. Get proper permissions on the shell script and (IMHO) get it working from the command line before you stick it in a DataStage job. And brush up on the concept of here documents so your END_SCRIPT can actually be used. Example 19-6 in the linked site has an ftp example but there are t...

Me, I wouldn't bother with the FTP stage for something like this. Get a script working from the DataStage server and use that instead. Which means first making sure you can do it manually from the ETL server command line...

And here I was thinking about chiming in on this... thank goodness I didn't have time last night. LOL

One solution would be a custom routine, one that checks the current date/time for the conditions you require and then passes back true or false. Your triggers coming from the Routine Activity stage can use that answer to know what to do (or not do) next.

Isn't this basically the same question you asked in this post?

I already did... I undid the premium bits so you can see the whole messages as there wasn't all that much you couldn't. Let us know if you need any other clarifications.

Correct - my reply was specific to the hypothetical, hoping at some point you'll come back and clarify exactly what it is you need to do or meant to ask. Still though, nothing can be 'manipulated' per se - you design the sequence to run or not run individual activities as needed.

<crickets>

I would suggest you write your script and execute the script using the Execute Command stage, this rather than putting the ftp commands directly in the stage.