DSXchange

I would bet money this command works in the next release. I doubt if the next release changes that much. I think a lot of these types of hacks are the only way you can get this information. If the information is valuable then get it and use it. Hack the new later. Using the macros are better when th...

I hope someone corrects all my old posts. Thanks.

Ray is correct. I modified Ray's routine to create DDL and get row length from knowing how DS_METADATA works. He hacked this one, not me.

Ray wrote a routine to export these records to a XML file. The key to this hashed file look like ODBC\DSN\TABLENAME. I am not certain how the OCI keys look but you can import them to any key you want.

How much does it cost?

Why would I want to?

Never mind.

Can I get a mention?

Wow, Ray is quoting me now.

select NAME, CATEGORY from DS_JOBS;

Your .profile is not executed when a job runs. PATH should be set in dsenv but it is always useful to source it in your .profile.

Thanks again, Kumar. I think there are some more directories like catdir which need 777 permissions. I am not sure without the script. I will look it up.

Sorry, I misread. I thought you wanted a filename in a sequential file stage. You are going to have to hack a solution. Like the one I have for sequential file stages.

What version are you using? I have workarounds for both UNIX and DOS.

Attachments did not work till either Ds7.5 or Ds7.5.1.