DSXchange

Hi ray,

I agree its not good to reindex the project al the time. But I need to do it via a script whenever I wish to do it or when I have huge migrations into the project.

Thanks,
Renita

Hi, I was writing a dataStage automated maintenance utility as bat and shell scripts and as a part of it I wanted to know if we can reindex a project using a command line option. I am aware that we can use REINDEX.ALL in the command line of admin,however I want to either incorporate this in a script...

Hi Chulett, I found a write up on the ibm ascential site which states the following. DESCRIPTION: Using using DRS Stage with DBMS Type = ORACLE, and the number of characters in the generated SQL FROM clause exceeds 64, running the job or performing a viewdata causes the uvsh and dsapi_slave to produ...

Hi,

I got the solution for this issue. Its a bug in DS version 7x with DRS stage and Oracle database which has been fixed in version 8. If I use database type to ODBC and view data I can view data.

Thanks for all your help.


Renita

Hi Chulett,

I hardcode the user id and password just to view the data cause I cannot use $PROJDEF when i view the data.


Thanks,
Renita

Hi Chulett,

When I need to view data i explicitely provide the database name,user id and password. It does not refer to any variable for the id or password.

Thanks,
Renita

Hi Chulett, I have finished the configuration related to Oracle. The dsenv has been setup correctly all all environment variables are set. The maps run successfully, hence the server can connect to the database. The outputs also are correct. However the problem is only with the view data via the dat...

Hi Hemant,

The issue exists even after using the while condition. Actually the stage cannot even fetch 3 rows or data and errors out before that.

Thanks,
Renita

Hi Chulett,

I have this issue with all jobs using the Oracle database. The database is set to Oracle.

This problem persists on other projects also on the same datastage server.

Also the problem exists for database stages that are source or target stages.

Thanks,
Renita

Hi chulett,

I agree !! But who would convince the developers!!

I would have to go and change jobs from development to Production for that. Any idea with DRS instead?

Thanks,
Renita

Hi, I am on datastage Server edition 7.5.1 on AIX server. I am connecting to an oracle database via a DRS stage. The map runs fine, however when i try to view data. I get the following line or error message Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in proje...

Hi, I got a reply back from the admin where they say that for their datastage edition 8.0 this issue got resolved using ASCL_EBCDIC-1026 character set. However I am on 7.5.2. Since we are having an issue with just the I character in turkish, does anyone know if there is any fix available for the sam...

Hi, I got a reply back from the admin where they say that for their datastage edition 8.0 this issue got resolved using ASCL_EBCDIC-1026 character set. However I am on 7.5.2. Since we are having an issue with just the I character in turkish, does anyone know if there is any fix available for the sam...

Hi ArndW. I am in the process of getting teh NLS setting from the SQL database admin. However when I have just a database stage ii.e DRS stage and connect to the SQL database to recover data from a table, I see the o character with 2 dots but not the I with a single dot. I saw a post on IBM which sa...

Thank you for your prompt response. However, the map still does not give the output correctly. The 'O' character displayed with 2 dots on the top shows in the output, however the 'i' character with the dot shows up as '?'

I am using NLS ISO8859-9 and Turkish character set.

Please advice.