DSXchange

Have a look under the NLS settings.

sharmabhavesh wrote:Any help on this? Even I am facing a same scenario with one of my code pieces.

And what have YOU tried? Is your requirement identical to udayanguha's? If not, you should really start your own thread.

ecclesr wrote:At this stage I not able to achieve a connection

"Successfully connected to the database." in the test result gives the lie to your statement.

If you installed DSODB tables in the XMETA database, even though in a separate tablespace, try accessing its contents via XMETA but specifying DSODB as the schema name, for example SELECT * FROM DSODB.tablename;

In a dynamic hashed file the number of groups (also known as modulus) can change second by second as data are added and removed. Hence the term "current" as at the time the utility (possibly ANALYZE.FILE) was run. The minimum value for number of groups is set by the MINIMUM.MODULUS keyword...

What error entries are in the log of the parallel job itself when it fails? (You have shown us entries from the sequence's log.)

Not all fields in the UV.ACCOUNT hashed file are visible by default. Project protection status is in one of the fields that is not visible by default. You need to ascertain which field number it is and use the EVAL "@RECORD<11>" AS PROTECTED syntax to display its value (assuming it's field...

Note that what Craig suggested is not "manipulating individual activities". His approach is to use custom triggers to determine whether the activities run at all. This is a valid approach. But, again, your overall requirement remains vague. You'll need to tighten your specification before ...

Check which Oracle environment variables are set in $DSHOME/dsenv, and to which values.

No.

You must have the Suite Administrator role.

Nothing you do with, to or around the script will alter this fact or allow you to use the script, until you have this role assigned.

It is NOT enough to be a DataStage Administrator.

None of which I'm aware, given that you're on UNIX.

And what do you want to do when invalid numbers are found? For example you could populate the InvalidData field, and possibly InvalidPattern if this were pertinent.

What is the "this" to which you refer? The DataStage command line interface (dsjob) can be issued from any directory. There is no restriction that you have to be in project folder to use the dsjob command. However it is usually far more convenient to execute it from a project directory bec...