DSXchange

Load the file to a work/temp table and join it to your source.

I am using custom sql, and I am not using any TO_DATE() Function. I would have bet the house that was the answer. Learn how Oracle DATE fields work, in particular in conjunction with the TO_CHAR() function when selecting one and TO_DATE() when loading one. Talk to your DBA on the subject. You need ...

leka.sm wrote:i want to add a username to /etc/groups.

Unless you are a SysAdmin for that server, you can't. Find out what the process is in your organization and put in a request for a new user.

As noted, a completely different question. Next time, new topic please. And as noted, the Field() function can be used to parse a delimited string into component pieces, and your address and code fields are ';' delimited strings. Check the online help.

Um, yah.

How can we know? Give us an example (a real example) of this address data and what your business rule to 'split' it is.

Write it to a file as noted, then read it back before loading to a table. All in one job. In your example, you would write 7 'records' but read back 10.

Windows? I could have sworn when I looked at it before replying it said UNIX. Trickery!

Yes, of course, Windows will need the pair of CR/LF characters as the record delimiter.

Right, but look beyond the subject to the reason why they are 'connecting to UniData6 from Designer'.

That will write out "5;5;6;7" as four records at once since CHAR(10) is a LineFeed a.ka. UNIX record delimiter.

You could run the query using DSExecute with the ShellType set to 'UV'. And that from inside your existing routine that is calling DSGetJobInfo, I would assume.

Ah... I see that's where the 'backwards link' corruption is. Yucky.

No, not really, but I guess I'm confused. Why would you be using UniData to access DS_JOBS, DS_JOBSOBJECT, etc? You just want a UV stage with the DSN set to 'localuv' do you not? There's no ODBC setup required for that.

Search the forums for JOBTYPEIND to get a list of 'valid values'.

UniVerse, not UniData.