DSXchange

Actually, many users tried from many machine with the same result.

Sure there is, Ray. Plenty. Me is the one of them.

ray.wurlod wrote:Do you log in with administrator privileges?

Yes, Ray. I logged both as dsadm and as myself with the same result.

When I open Cleanup resources in Director in one of our DataStage installations and then click on Show All in upper Processes window, no processes show up. It is an old installation where this feature definitely worked before. The only place I know is related to it is in Administrator, Project prope...

2. In every multi-value field replace commas with @VM (char(253)) You mean @FM :wink: But how would you then read from the hashed file with 12 defined on your output ? No. I really mean @VM. :P That is how multi-value fields are reconized in hash file functionality. @FM will convert each multi-valu...

I don't understand why you are using an ODBC stage at all, surely two enterprise DB2 stages would be better. If they are two different remote DB2 databases you might have a problem with clashing environment variables. See the DB2 Remote Configuration Guide, if you don't have one ring Ascential-IBM ...

For sparse lookups there are several restrictions. Among them are that only DB2 Enterprise and Oracle Enterprise stages may be used, and that these must be connected directly to the Lookup sta ... I just checked again, and it is not really a sparse lookup problem. When I tried to read from ODBC rem...

Krazykoolrohit wrote:No Error codes?

Sorry. Nothing.

Krazykoolrohit wrote:Please post the full error.

That was a full error in my original posting.

It looks that your DB2 driver is not working. Try and test the DB2 driver. ie connect to the table using something other than Datastage. contact your admin to check it up for you. Driver is OK. We are running a number of jobs that successfully load that database using this stage. But in those cases...

samsuf2002 wrote:check the odbc connection and try using join instead of look up.

ODBC connection is OK. Like I said, if I replace target with ODBC istead of DB2 stage, job works.
Join is not an option. I do not want hundreds of millions of records travel through the network to select less then 1% of them.

Sorry. Can you please delete this post. I moved it to PX forum. Thanks

I have a job design as follows: odbc stage (remoute DB2) | | Seq_file stage ----->Lookup ---------->DB2_UDB_Enterprise stage stage (local database load) (sparse lookup) When I ran it I've got an error: main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC lib] Driver's SQLAlloc...

I am new to PX, but I know Server pretty well. I used to create ODBC unload/load jobs in DS Server omitting User ID and Password. Then at runtime the connection acquire these values of whoever runs the job from the system. I tried to do it in PX and got password/uid incorrect message. Does anybody k...

There is also Count function:
Count (string, substring)
Returns count or null