Search found 8 matches

by mceccaro
Sat May 25, 2013 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: view data error on the Oracle Connector
Replies: 2
Views: 4332

Hi Pedro,

when I run the job all it's ok and the job don't have problem!

Massimo
by mceccaro
Thu Apr 21, 2011 6:52 am
Forum: General
Topic: "Empty DSN: list returned from host XXX" Windows
Replies: 6
Views: 11179

I say 'bug' because I have the same problem in:

Server Windows 2008 R2 x64 (64-bit) environment with DataStage 8.5.
by mceccaro
Thu Apr 21, 2011 4:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Setup - Empty DSN: list returned from host
Replies: 16
Views: 16248

I had an issue with ODBC read from the uvodbc.config file where if I cut/paste all the entries in the file, then i may have inadvertently added hidden characters. Please type in the dsn entry and after you have doen it press enter. For some reason this must enter a delimiter that the ODBC driver un...
by mceccaro
Thu Apr 21, 2011 4:34 am
Forum: General
Topic: "Empty DSN: list returned from host XXX" Windows
Replies: 6
Views: 11179

Is a bug Datastage that looks for 32-bit ODBC connections!

Workaround:
In win 2008 r2 64bit should force the creation of the DSN 32-bit (64bit creates them by default) by running the% systemdrive% \ Windows \ SysWOW64 \ Odbcad32.exe.

You should see the DSN in the import table definition

bye Max
by mceccaro
Thu Sep 11, 2008 4:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error reading from AS400
Replies: 1
Views: 5751

Re: error reading from AS400

Hi All, I am gettinng below error while reading from AS400 through ODBC stage ERROR : SQL0913 - Row or object type *FILE in use but no one locking the file Has anyone any ideas........... The OS Im using is Windows 2000 Thanks resolved by myself: I must set the option Isolation Level = Read Uncommi...
by mceccaro
Wed Sep 10, 2008 4:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error reading from AS400
Replies: 1
Views: 5751

error reading from AS400

Hi All,

I am gettinng below error while reading from AS400 through ODBC stage

ERROR :
SQL0913 - Row or object type *FILE in use
but no one locking the file

Has anyone any ideas...........
The OS Im using is Windows 2000

Thanks
by mceccaro
Thu May 24, 2007 3:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Reports
Replies: 2
Views: 1792

Re: Job Reports

Currently I am using the DSJobReport in the after subroutine to view the job log. I would like my log to be exactly the same as shown in my director. For my job I would like this log to be in a certain directory. Where do I specify it ? After Job subroutine which writes a Job report to a file Input...
by mceccaro
Thu May 24, 2007 1:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQLFetch failed in AS400
Replies: 1
Views: 1824

SQLFetch failed in AS400

I am getting an intermittent error like odbc fecth failed after processing some number of rows. Actually i am trying to pull the data from db2 table using the odbc stage ,some times it will goes fine and job is getting successful ,once in a while i am getting the follwing error: DSD.BCIGetNext call ...