DSXchange

in the source does "view data" show the data correctly for the date? If you sort via "date" then the order won't be as expected, since the format is dd/mm/yyyy; in order to correctly sort this ascending or descending you should convert the field to the internal format using ICONV(In.Date,"d4/DMY') a...

What about the contents of the job showing as "server"? Does it compile? Does it run? Does it contain PX or Server stages?

I know of no way to convert a PX job to a server job automatically. A "Save as" won't work. Does the server job actually compile & run?

Why are you certain that the failure is due to this conversion? Have you changed the output to a PEEK stage in order to see if teh conversion works?

Where are you checking the value? If in a view or peek I think it uses the *s to show a non-displayable value. To be 100% certain I'd dump that to a database nullable column and check the value there.

One of them is on disk, the other exists only for the duration of the job.

You have stated your format is both "2004 04 10 12 24 24" and "20040202122324". Which is it? Is this even an issue in the multiload insert?

Unless you have run out of disk space, the most likely cause is that your userid doesn't have OS level privileges to create files in that directory.

yulangok wrote:Fatal Error: Fork failed: Not enough space

is a message from your OS (you can look that up using google). What OS do you have, what are the ulimit settings, how many nodes in your APT_CONFIG file?

The maximum length is certainly much higher than either 1000 or 3600. If you look at your source file in an editor, are you certain that there are more than 1000 characters in the column that is being truncated?

Can you create a small dummy job, with just a single column row generator to a BASIC transform stage that just passes the single column out to a PEEK stage? Does that compile and run?

I didn't use any special sort settings, just defined the first column as a key.

Try StringToTimestamp(In.Stringcolumn,"%yyyy %mm %dd %hh %nn %ss")

vinodn,

please read the PDF first, then try what it says and if you still have problems, post it here.

days_since_from_date