DSXchange

FYI: From development guide: DataStage doesn't know how large your data is, so cannot make an informed choice whether to combine data using a join stage or a lookup stage. Here's how to decide which to use: There are two data sets being combined. One is the primary or driving dataset, sometimes call...

Or you can set it to your working directory as mentioned above

Can you please post the path to the c++ compiler APT_COMPILER , APT_LINKER and APT_COMPILEROPT it the later two are set.:
Also Does your $PATH include "/opt/SUNWspro/bin"

Did you mention 'abc%'?. The filter stage expects the exact record value in the where clause. To solve this you might want to create another field in the input record to the filter stage and populate it with a subsrting of the original fileds so that you can specify the exact value as 'abc' in the f...

Naveen is there a difference between Outlink.Col = '' and Outlink.Col = ""
please note the difference in cotes

Telsi, It is important to know how much scratch disc is avalilable. since sorting takes place in the scratch, I doubt the volume you are refering here can be handled in the scratch with out effecting other applications. I agree with others on considering a database join .

This shoul dbe under your project folder usually your project folder is under $DSHOME

Somu, You might as well consider using a sort stage between the db2 lookup stage and look you stage. The advantage of using sort stage is two fold.
1) you can remove duplicates
2) Having sorted data will help improve performence.

Thank you madhav. The solution you are proposing is very interesting I will defenatly ask my DBA to try this.

where did you specify the LIBPATH. in dsenv or environmental variable level. If you do not specify the in DSENV you will not be able to view data by view data tab but will be able to run the job.

You need to run UNLOCK from UVSH utility by logging onto the project from command line. If this does not work you may have to reboot the server

I belive DB2 EE stage would not work for hetrogenious systems. Use db2 API Stage instead. I am sure If the operating systems are different then DB2 EE stage would not work.But you may still want to double check with ascential since the remote Operating system is the same.

FYI: Why I do not want to use Db2 varialbles at project level is that the view data tab wont work and also importing metadat is not possible as it needs db2 entries in DSENV file

Womawil: The database is cataloged as I mentioned. And we are able to connect to database via the command line. there is no issues with db2 cataloging and still it does not connect unless we change the dsenv to point to the db2 v8.2( doing this we would not be able to connect to db2 v7.1: Another wa...

Comments needed: I am having problem connecting to db2 on a remote Aix box. We have two instances of the db2 V7.1(mainframe) AND V8.2 ( unix Aix) . Datastage is on solaris. db2 client for 8.2 is installed and is cataloged and the connection to database v8.2 is perfect when tested through command lin...