DSXchange

I think that the problem may, indeed, be a bug. OCONV could be being called by DSD.BCIOpenR (which opens the connection for reading). With the ODBC stage, if a data element is set to Date or Time, then an "implicit" conversion is performed - it's most likely that this uses Oconv (or Iconv, depending...

I'd also be asking whether there really are "}" and "|" characters in the data, or whether these are being translated from value marks and field marks.

Everyone seems to be bypassing your complaint that you do not have the source, and for a very good reason. This problem cannot be resolved without the source. You will need to reconstruct the job from original specification documents.

I have been doing some PX training in India recently, but it's for a particular customer and using their own data, so I doubt that they'd be happy about allowing outsiders in. Ascential claim to be able to provide training in India, using a service delivery company in Chennai. For further informatio...

I suspect you're right (that you can't select from a view in parallel streams). Check with your DBA or database vendor. Even so, you can still use parallel jobs. Sure you're reading the view as if it were a delimited text file (in a single stream), but that will be partitioned by DataStage into a Da...

Pivot stage is a good call. Just make sure that its input link has enough columns to cope with the largest possible list of states. (50 is probably over the top, but is fail safe!)

Welcome aboard! :D Yes, you can run queries directly on the Repository, but it would be like putting lipstick on the pig. It adds nothing, and it annoys the pig. Rather than try to get at the actual tables, MetaStage provides two materialized views that vastly simplify the task of getting informatio...

SET.INDEX DS_JOBOBJECTS INFORM Record the location of the indexes directory. SET.INDEX DS_JOBOBJECTS TO NULL Now DS_JOBOBJECTS believes it has no indexes. Now effect your repair. fixtool is $DSHOME/bin/fixtool - executed alone or with -H command line option it will generate syntax help. SET.INDEX D...

What Kim suggested is exactly what I was going to suggest once I'd clarified that's what you were seeking to do.

Can't you just make sure that "-", "," and "." are in your STRIPLIST ?

Not sure why you'd want to force the third character of the first column to be "3", so I'm assuming that the problem there was with the keyboard (or, at least, between the keyboard and the chair).

Please let me clarify. What you're trying to do here is to use metadata (column name) as the basis of a lookup reference key expression. Is this correct?

Any solution to this will be messy, so please verify my understanding before I waste time giving incorrect answers.

For starters, the option must be in lower case: sort -u

Secondly, you will almost certainly need to specify at least one sort key (using a -k option).

It is a fundamental rule of databases that order of storage is not determinable. The database server makes its own decisions about where to store things. Unless you specify ORDER BY in a query to retrieve those data, you'll get whatever the database server chooses to give you. This is NOT a DataStag...

Then again, you might have a corrupted DS_JOBOBJECTS on your backup. Even so you're in a better position to attempt repairs. uvfixfile without the -fix option will tell you whether repairs are necessary. You can then use either uvfixfile or the newer fixtool to effect repairs. However the danger sti...

CLEAR.FILE takes a command line argument indicating the table whose data are to be cleared. It was you, in your original post, who claimed to have executed a CLEAR.FILE command. If you didn't specify a table name, then the CLEAR.FILE command would have prompted for one. What name did you provide?!!