DSXchange

Define as varchar and check within a transformer or custom routine. You could have had that coded by now.

ArndW wrote:Here with 8.0.1 and AIX the list is:

2809, 9043, 9080, 9100, 9403, 13400, 13401,31531, 31533, 31538

Arnd,

What did you do to get this port list?

Struggling here the same as Vincent.

-Craig

Good luck.

So, do you have a solution to share?

Also, PREQDB isn't a SID, it's a SERVICE_NAME.

Do you have this set in your dsenv?

APT_ORACLE_NO_OPS=1;
export APT_ORACLE_NO_OPS

Needed for accessing a RAC that is not resident on the same server as DataStage.

My experience with dates on input is to define them as VARCHAR 10, then analyze and default them in a transformer.
Else, you run into issues of format, defaults, nulls, null lengths, null values... not worth it trying to define it in the schema.

-Craig

figgered

Craig who?
Congrats!

FYI, 4.5 hours

Anyone have experience installing a minimal 8.1 on Linux? I'm loading on a single box just for evaluation purposes (not intended to run any jobs of any size). The box is a VM with 2 CPU's and 4G of memory and one disk. The install script indicates I'm less than 1/2 the way through and at that point ...

A similar post I felt should have answered this problem for us, but it hasn't yet. The post is www.dsxchange.com/viewtopic.php?t=103819 Well, we have the current issue where the error text is: "DSU.UtilityAbortToLog is not cataloged" Rumor has it that a previous developer altered the stand...

The poster initially said he/she was running orchadmin from the command line.
Also, sourcing dsenv isn't necessary in order to run orchadmin, since a "standard" dsenv doesn't include the PX load lib, nor a config file.

At a minimum, only load lib and config file need be set.

I think they could safely be added to the dsenv.... I'd make sure the PATH and LIB are appended to the end so as not to interfere with pathing that DataStage likes for the dsenv (may not be an issue, but safer). One may have a particular preference for a config file. If set in dsenv and everyone sou...

usually, but for orchadmin you need a couple extra env variables not in the typical dsenv... I have this in my .bash_profile specifically for orchadmin, what you need is similar... . /appl/Ascential/DataStage/DSEngine/dsenv PATH=$PATH:/appl/Ascential/DataStage/PXEngine/bin LD_LIBRARY_PATH=$LD_LIBRAR...

Another thing to look for, similar to Ray's last response... The data used to load the hashed file... Does it contain non-printable characters that are somehow being used as value marks or field marks or whatever Universe uses to denote multivalues in the row (probably not said correctly, but direct...