DSXchange

I first use "-jobinfo" to see if the job exists and is in a runnable state, but with no looping as if it is running, I exit the script. Then if the job is aborted and needs to be reset, I do that with just "-run -mode RESET" and then a "sleep 5" before issuing the real run that uses "-jobstatus". My...

Welcome! :D First suggestion would be to go to Kim Duke's website: m And download something he stores for us there - the TwoTechTips.zip file on his Tips page. One of which will walk you though creating SCD jobs in Server. You don't need CRC32 for this but it can help when you have a large number of...

He is suggesting you need to create a symbolic link (or soft link) so that the software can find the jre. The question in my mind is where exactly you need to create this. And depending on permissions, you may need to get a SysAdmin to do this for you.

In the past you were locked into having 'dsadm' as your admin user and so most people still continue to use it. You are no longer required to use that name, however, so I would guess 'psoftds8' is your equivalent. Think of it as the root or superuser for DataStage. PeopleSoft support has told me the...

Sure, but that will solve one problem and probably create a slew of other ones.

Your error would imply that the job is currently running... is it? As Ray noted, Cleanup Resources from the Director client can be used to 'logout' (kill) that process. And to release any stray locks as well.

Native MSSQL connectivity is only available on a Windows based Server, which is why you won't see the MS OLEDB or MS SQL Server Load stages on a UNIX install. If (like myself) you've only ever worked with UNIX servers, it can make it seem like they don't exist. Rwe - can you post how you defined thi...

Please post the exact error that you receive. Also, does everyone have this issue connecting or are you the only lucky one? You will need a UNIX id on the DataStage server to authenticate against and there's no such thing as a UNIX id that doesn't belong to any group. Obviously, being in the 'wrong'...

That's how View Data displays a float. Have you tried writing it to your target and viewing it there yet?

You haven't said what exactly your issue is. It would also help if you posted your actual derivations.

Not a DataStage thing nor something you can do, but a normal UNIX thing that you need your SysAdmins to check for you.

Nope, it likes to have a primary input but it is certainly not required. Add a stage variable to the transformer and it will then compile. No need to use it, it just needs to exist. With that in place, your constraint controls how many 'records' the transformer generates. Using @FALSE or '1=2' as yo...

Sorry, but I don't speak French.

Ensure you have the schema properly handled as well as the table name. And double-check your grants with your DBA, if you don't own the table you won't have permission to truncate it without a specific grant.

ps. You shouldn't need the 'trigger file'.

Or perhaps explain why you 'need' to write to a flat file.