Search found 11 matches

by ar_shriks
Sun Jun 15, 2008 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping Network Drives
Replies: 6
Views: 2255

What kind of network and mappings are you using? Can you explicitly mount these drives for all users?


I'll have to get this information from our sys. admin. I'll take up this issue with them and see what they can do.

Thanks a lot ArndW.
by ar_shriks
Sun Jun 15, 2008 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping Network Drives
Replies: 6
Views: 2255

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".
by ar_shriks
Sun Jun 15, 2008 3:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping Network Drives
Replies: 6
Views: 2255

Thanks Ray. But, I was able to read only part of your response as I am not a member.

The ALLOWNFS is set to 1 in our server.

Regards,
Shrikanth
by ar_shriks
Sun Jun 15, 2008 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping Network Drives
Replies: 6
Views: 2255

Mapping Network Drives

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...
by ar_shriks
Thu Jan 25, 2007 4:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Modify Schema Name in OCI9
Replies: 4
Views: 2427

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...
by ar_shriks
Thu Jan 25, 2007 2:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Modify Schema Name in OCI9
Replies: 4
Views: 2427

Modify Schema Name in OCI9

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...
by ar_shriks
Tue Aug 30, 2005 1:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File (mis)behaviour
Replies: 2
Views: 1397

Hash File (mis)behaviour

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...
by ar_shriks
Mon Sep 06, 2004 1:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Connection Issues
Replies: 5
Views: 3947

DS Connection Issues

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...
by ar_shriks
Mon Aug 16, 2004 12:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character Set Problem in ORAOCIBL
Replies: 7
Views: 5014

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?

Regards
Shrikanth
by ar_shriks
Mon Aug 09, 2004 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character Set Problem in ORAOCIBL
Replies: 7
Views: 5014

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?
by ar_shriks
Mon Aug 09, 2004 1:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character Set Problem in ORAOCIBL
Replies: 7
Views: 5014

Character Set Problem in ORAOCIBL

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...