DSXchange

HI

The source and target connections are working fine. But when I run the column analysis i am getting following error


Router :[5874305.92408369.5gbk1uj9.mmccc] is not enabled.

Please help me to fix this issue

thks

hi I am trying to load UMF file from DataStage to Oracle database 11g. French characters are messed up in Oracle database.It shows correctly in Linux. DataStage column : UStringToString('UMF TAGS'),"ISO_8859-1:1987") code page is UTF_8 Database Oracle :NLS_LANG - AMERICAN_AMERICA.AL32UTF8 ...

HI

I am getting following error when i run the IA column analysis

can you please help

java.sql.SQLNonTransientConnectException:[IBM][Oracle JDBC Driver][Oracle ] ORA-12505 Connection refused .The specified SID (IADB) was not recognized by oracle server.


thks

Hi

Thanks for your reply .back up every thing using the automation tool looks complex. Is there any other way so that we only select back up files need (send me list of imp config files)


Is it possible to change the location of IADB .bec we have DB2 and xmeta is on oracle.

thks

Hi

We just upgraded to PX 8,7 ..when i tried to delete the records when the table is empty i am getting following error


SQL0100W : No rows was found for FETCH,UPDATE OR DELETE or the result of query in the empty table SQL STATE -2000

this was working fine in 8.5.

Please share your ideas...

Hi

I am selecting 10 million from a DB2 TABLE in Z/Linux .but i am getting error as limit reached time out..



how can i fix this issue ...how can i fine tune this in datastage ...
DBA dont want to increase time ... and the table is not yet partitioned ...

Hi I have a parallel job which updates to 6 different tables ,I have around 3Million source records... What is the best may to design jobs (In single job or multiple jobs) Also I have target DB2 in Z/os.I want to do bulk load ,but this feature is disabled in datastage ..how can i enable this in data...

hi I have sample data in a column which i have to parse the code in each seperate row, ;abc;def;ghi; when i tried to use while condition @ITERATION <=Dcount (which is count of ';' delimiters) Datastage is saying it is not valid...the datatype for Dcount is integer ... please share your thought thks

Hi

I am just doing a normal lookup from data set file..

I noticed that data stage is inserting Zero value for null fields after lookup. I saw the value in peek stage and datatype is Integer ,,,


I just want to confirm is this is true,,,

please confim


thks

HI

I have child table foreign key as Nullable.
When i tried to insert null ,Datastage is converting to Zero and try to Insert.

Zero is not value in Parent table ...


Can you please clarify why datastage is converting from null to Zero

thks

Hi

Every day we get this error ,some times we restart the datastage box it fixes this issue...

I jusy want to know how to fix this issue completly ..

is this a DB2 issue or datastage issue ...

please share your views...

Hi Currently I am inserting data into DB2 from dataset file which is created in perious job and i am getting following errors Target_table: Schema field xxx_ID in input data set 0 not present in design time information. Extended field properties for this field will not be available. Target__Table: S...

Hi

I am loading data to 19 tables parallel .I want to generate Unique Surrogate key .If i use surrogate key stage in the shared container

will it works ? can it assign unique key in all the tables...


thks

Hi

We are doing development of jobs in windows version (Datastage PX using CDC).Once development server is ready we will export to Z-Linux..

What steps we need to consider when designing the jobs in windows.


sainath

Hi Thanks for your comments.. I am using ODBC Connector stage.. I mean when i was using convert function in SQL to convert from float to decimal (10,2) , I got some error as invalid operator(Yellow mark) , But i can view data and my connection is also working fine.. And my job also running fine..I j...