I provided the UNC name and the job works fine when I run it from Director. But when I schedule the job it gives the error "DSD.SEQOpen Unable to create file \\server\path\filename".
Hi all, We have a requirement to generate to sequential file output to a different NT server. We have mapped a drive to the remote server from the datastage server. We are unable to see this drive when we select the output location for the sequential file. Do we need to do any additional configurati...
Thanks. But when you create the query by clicking on the 'Build' command button and selecting the table name, the displayed table name in the 'Selected tables' list is read only and in the format schemaname.table_name. Is it possible to list the table name without the schema name so that my SELECT c...
I have a job with Query Type : "Fully Generated SQL Query" reading from an Oracle database. The SQL query looks like : SELECT FIELD1, FIELD2 FROM USER1.TABLE_NAME; Note that the the schema name is USER1. Now, when I have to run the job from production database the schema name changes to US...
Hi, We have a job which looks as follows: Ora9i ----> Trans_1 ----> Hash1 -----> (Further Stages) The output Link of Hash1 is a reference link to further stages in the job. Output row counts: --------------------- Ora9i to Trans_1 = 5150800 Trans_1 to Hash1 = 5150800 Hash1 to Further Stages = 515081...
We have installed Datastage (Version 6.0) on a Windows 2003 server. We are in the process of migrating all our datastage jobs to this server from the existing Windows 2000 server. We have the following issues: Problem 1 ========= 1) While loggin on to datastge, if we 'Omit' the user name and passwor...
Sorry! I made a mistake with our Datastage version. It is 6.0 and not 6.1. We see from the installation notes that NLS is not supported in version 6.0. What do we do now?
Craig, can you as Ascential support about this please?
We don't see any way of specifying a valid character set in the ORAOCIBL stage or anywhere else in data stage. Where in data stage can we specify the character set of our Oracle database?
We are getting the following error message while trying to load data to an Oracle9i database using the ORAOCIBL stage. We are on Datastage 6.1 on a Windows 2000 server. Test9i..ORAOCIBL_3: Internal Error:Unable to initialize the Direct Path Context ORA-24329: invalid character set identifier. We rec...