DSXchange

Well, DHCP wouldn't help much if you put a static IP in your hosts file, would it?

I have data like this Location Timezone 1000 CST 1000 PST 1000 EST 1000 1100 IST 1100 1200 1300 GMT 1300 CST My Output should look like Location Timezone 1000 1100 IST 1200 1300 How Can I get this .....sort keychange is not helping i.e if there are multiple timezones i need to keep null else data

I cannot understand your rules for getting from your input to your output. Could you perhaps explain what your are trying to achieve?

Char(34) is the double-quote character, which is expected in position 161 of the line to close off the "DateDrawn" field but which is not present in the data. Open that file in your favorite editor and analyze the line in error. Most likely some field on that line is shorter/longer.

Yes, add the name and ip of the virtual machine to your Windows hosts file.

If you purchase the PX product then Server is included. If you purchase the Server version then you don't have PX. There is a "Version.xml" document on disk that can be checked to see what you are entitled to use. I'm not sure about the Oracle OnDemand, but since DataStage writes to tables...

DataStage server has no timestamp, just Date and Time, so both parts need to be done separately. Assuming you have a string input value you need to: Step 1, convert date to internal : ICONV(In.Date[1,10],'D4-DMY') Step 2 convert internal to date : OCONV(Step1Result,'D4-YMD') Everything in one line: ...

I doubt that the characters are "?", just that the tool you are using to display the data doesn't handle NLS correctly. Can you check the binary/hex values?

(1) Not easy. You could enter the uvsh then issue a "LOGTO {Projectname}" command.
(2) "PTERM CASE NOINVERT" will do the trick for you.

You will need to define a System DSN on Windows. You can check to see if the DSN work using the tool of your choice, I usually use MSQuery on Windows to check that. Once that is working, it should also appear in your list and function in DataStage.

You need to change the limits of the user under which the DataStage jobs run and then restart the DataStage engine.

<If your platform is LINUX, ignore this post. I didn't read the full problem description. >

Your user with which you are accessing the database doesn't have sufficient privileges. Where are you getting this message? Is it a new installation (note the section in the installation guides which tells you which GRANTs must be made in order for DataStage to work correctly).

Yes, please post your code. Somewhere you have a badly formed EXECUTE or PERFORM command.

No, Parallel and BASIC transform stages are very different in how they get executed. I wonder if this isn't a message from the repository. (quick login to our XMETA) There is no table with that name, but several starting with OMDMODEL... so it is likely a repository error after all.