DSXchange

IBM support tells me Information Server 8.1 is 64-bit on AIX.
In this case, $ORACLE_HOME/lib and $ORACLE_HOME/rdbms/lib , not lib32 should be included in $LIBPATH.
I will do a testing and update this topic later.

Hi all, I install Information server v8.1.0 on AIX 5.3 . I have searched the forum, but issue still can't be solved I add following env to dsenv. ### ORACLE Environment Variables ### export ORACLE_HOME=/opt/oracle/oraInventory #export ORACLE_SID=etl export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export P...

Dear,
you need switch to Ascential/DataStage/PXEngine/etc. and modify db2_cs.txt. Add mapping between ASCL_TIS620 and DB2 codepage.
Good luck!

Did you install C++ compiler on your OS?

thanks ,ray.
I found root cause.
The root cause is someone ran command: chmod -R 777 $DSHOME.
I think reinstallation can resolve this issue.

Hi all,

I also met same issue.
Formerly I can start datastage without inputting password.
Now it required password when I started datastage as dsadm.

Which reasons may cause this issue?
Thanks for any help.

If File B is very small, I can list all possibility of the Key.But the problem is Range is random and File B has about 20 million rows.I can't list.

Dear all, How to implement complex lookup in DSEE? Here is the description of problem: I have 2 files: A and B. And I want to get file C through following arithmetic: File A: A1 A2 1 X 3 Y 5 Z File B: B1 B2 B3 0 2 U 2 4 V 4 6 W Lookup condition: (A1 >= B1) and (A1 < B2) Result file C: C1(from A.A1) ...

Dear all,

I can set NLS to NONE in server job.But it seems DS does not support NONE in parallel job.How to disable NLS in parallel job?

Thanks for any suggestion.

add NLS_LANG in your dsenv.Make sure its value is same as db.

Hi somu_june, It seems datastage can't skip first N rows.But we can read all rows firstly,then filter by Filter Stage. You may choose Row Number Column in Sequential File Stage's Properties page.Name a value,such as RowNum.Add a column with same name in Columns page. SQL type:Integer .Then we can ge...

Looks like the dbisqlc program includes screen drivers. DataStage processes run in the background, and do not have terminal capabilities. This may explain why you got that error message. You need to ... Thanks,ray. Error occued because developer forgot to delete debug sentence which will print some...

Hi,
Ever I had same issue.Pls export your job,and import into a new project.Run it in new project.You'd better restart server before running.Good luck.

HI RobinM,
Thanks for your suggestion.It seems that DB2 EE stage can only delete rows which are same as input data.

Hi bozenna, I don't know the reason why you can't see full palette.Ever I have same problem.Please do as follows, 1.Open your Designer on server1.And create a new parallel job.Then right click on palette.Choose customization-->save as,give a name of palette file. 2.copy palette file on server1 to se...