DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 13 matches
Author Message
 Topic: ODBC Invalid Precision value
dskid

Replies: 4
Views: 135

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 09, 2018 2:12 pm   Subject: ODBC Invalid Precision value
Yes, this has been sent to support as well. Thought will check in the forum if some one has already went thru this issue before. Anyway i will update the thread as soon as i hear from IBM
 Topic: ODBC Invalid Precision value
dskid

Replies: 4
Views: 135

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 09, 2018 8:08 am   Subject: ODBC Invalid Precision value
Hi Ray,
In Target Oracle, it is defined as VARCHAR2(5000 BYTE).
 Topic: ODBC Invalid Precision value
dskid

Replies: 4
Views: 135

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 05, 2018 2:18 pm   Subject: ODBC Invalid Precision value
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Invalid precision value
Hi,
We are moving our jobs from 8.5 to 11.7 and our jobs extract data from SQL Server to Oracle 12c. These jobs are RCP enabled and we use ODBC stage for loading data into target.

This jobs extra ...
 Topic: Copy Surrogate key flat file from old to new environm
dskid

Replies: 2
Views: 379

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 18, 2018 10:04 am   Subject: Copy Surrogate key flat file from old to new environm
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: migrating jobs from 8.5 to 11.7
Hello everyone,
i am in the process of migrating parallel jobs from 8.5 to 11.7. some of my jobs use surrogate key's and we are using Surrogate key falte files in transformer stage. i copied all the ...
Resolved
 Topic: Is there any limit for query size in OCI stage?
dskid

Replies: 9
Views: 2443

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 08, 2007 7:58 am   Subject: Is there any limit for query size in OCI stage?
I resolved this issue by using ODBC stage. when i executed the same query using Oracle enterprise stage its triming the last characters in the query which are more than 1220 and throwing a fatal error ...
Resolved
 Topic: Is there any limit for query size in OCI stage?
dskid

Replies: 9
Views: 2443

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat May 05, 2007 7:01 am   Subject: Is there any limit for query size in OCI stage?
It seems there is a limit for No.of characters and its around 1220 for oracle and 2000 for teradata. i am able to run the same through ODBC stage without any issue.
thanks
Resolved
 Topic: Is there any limit for query size in OCI stage?
dskid

Replies: 9
Views: 2443

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 04, 2007 3:33 pm   Subject: Is there any limit for query size in OCI stage?
i was able to execute that from SQL plus. but when i try to do that from oracle stage its aborting and i am tryng it from ODBC stage.
Resolved
 Topic: Is there any limit for query size in OCI stage?
dskid

Replies: 9
Views: 2443

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 04, 2007 10:24 am   Subject: Is there any limit for query size in OCI stage?
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hello guys,
I am facing some problem related to Oracle stage. In my oracle TARGET stage i am passing a query which i am Selecting and Updating on the same table and that query is too big like it ha ...
Resolved
 Topic: unable to pad zero on left side
dskid

Replies: 6
Views: 2636

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 23, 2007 11:09 pm   Subject: Thanks a lot...
Thanks every one who responded immediately.
I choose to go with STR function and it solved my problem.
Thank you very much once again.
Resolved
 Topic: unable to pad zero on left side
dskid

Replies: 6
Views: 2636

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 23, 2007 5:12 pm   Subject: unable to pad zero on left side
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hello,
I am facing a strange problem when i try to concatinate Zero on left side of an integer its not takng that i dont know what the problem is can any one help me on this?
I have to check fo ...
 Topic: Warnings for decimal fields
dskid

Replies: 18
Views: 8397

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 05, 2007 3:40 pm   Subject: Warnings for decimal fields
Thanks us1aslam1us for immediate reply,
Is there any way i can avoid these warnings rather than handling after they were generated?
:shock:
 Topic: Warnings for decimal fields
dskid

Replies: 18
Views: 8397

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 05, 2007 2:17 pm   Subject: Is this is bug in Datastage
I too face the same problem alonge with this i am getting one more warning :( I am finding the count using the query in oracle stage and what should i give the data type for the count?
*Implicit ...
 Topic: Finding Child Level
dskid

Replies: 4
Views: 1097

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 07, 2007 2:35 am   Subject: Finding Child Level
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hello every one,
I have a requirment where i need to find the child level. My source data is like
A
...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours