DSXchange

They need a good... well, nevermind what they need. Create a standard routine that executes shell scripts. Then a Sequence job with a series of Routine Activity stages can run them. Or code a series of DSExecute calls into the Job Control tab of a Server job and run that. Or push back and tell 'them...

What value is the ETL tool adding to this? Why not just script it?

No, you don't need to be root. What happens when you switch it to 'Show All'?

The first field you define in the Folder stage gives you this information.

It shouldn't have anything to do with stage variables or job parameters, per se - that just means you haven't found the routine the job uses.

Look everywhere - before/after job, before/after stage, constraints, yada yada - could be in all kinds of non-obvious places.

And?

How about pasting the error message so we can see why it failed? How about indicating if my 'guess' is anywhere close to the mark? How about checking to see who owns the object it is trying to replace and what permissions it has?

Help us help you.

stivazzi wrote:i have taken the code...

How have you 'taken' and implemented that code? That could be part of the problem...

You don't need anything in the dsenv file that you don't already have.

So i have the information @INROWNUM from the Transformer Stage and want to write this information into the table LOGINFO in the After-SQL. (I assume, that the After-SQL ist called ONCE every run? Yes, you are correct that it is only called once, but that's not where you want to do this. Split anoth...

My requirement is slightly different. I dont want to delete all records. I want to delete some records based on some criteria. [sigh] Ok... that would have been good to note the first time. What kind of 'criteria'? Something you can encapsulate in a single sql statement it would seem, yes? Then you...

My requirement is , 1. Want to delete all records in a table. 2. Insert new records from a flat file. 3. If the insert fails rool back to the previous state. (Table with old records) I am using an oracle stage for inserting new rows. In the before tab of SQL in OCI stage, I am specifying the delete...

The link in my old post is still good although it will take you to the IBM version of the site now... and you'll need a new logon there. Once you have one, it's easy enough to find the patch that you need.

The only reason I'm aware of you wouldn't get it would be because your DataStage Server software is not installed on a Windows box. Do you get any kind of 'Exec' there? And which 'drop down' are you looking for it in?

Well, that post you linked to seems to indicate that you can't do the User Status thing in a Parallel job. If that is true then you'll need to do what both of us suggested and make this one job a Server job. But that doesn't explain your Sequence problem. Many things in DataStage are case sensitive....

Sounds like you haven't actually given the Sequential stage a Filename to use and it is still defaulted to the Link Name. Which means it is trying to create it in the current Project and you don't have permissions to create it there... probably because it already exists there. My guess, anyways. How...