DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 264 matches
Author Message
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 242

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 12:44 pm   Subject: NLS Configuration - Oracle character set to '?'
At the result, we have NLS_LANGUAGE = 'BRAZILIAN PORTUGUESE'.

Do you mean set the new environment variable with this content?
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 242

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 9:57 am   Subject: NLS Configuration - Oracle character set to '?'
Hmm ... and which environment variable do you set for it?

Actually the unique thing that worked was the 'Unicode' option (at the extended property) in each VarChar Column of the Oracle read link.
...
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 242

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 7:47 am   Subject: NLS Configuration - Oracle character set to '?'
What are the NLS settings for Oracle? Have you mapped these in DataStage? ...

Any idea, guys?
Where do I need to set to extract exactly the source characters, without replace some special chars b ...
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 242

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 10, 2017 5:49 pm   Subject: NLS Configuration - Oracle character set to '?'
That’s my question... what do I set at the administrator to correctly read this special characters from oracle? Like ‘ă’.
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 242

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 10, 2017 12:10 pm   Subject: NLS Configuration - Oracle character set to '?'
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi everybody.

I am running a very simple job, basically ORACLE CONNECTOR -> DATASET and when job reads a varchar field with tilde, for example, it set the character '?' instead.

Example: Săo ...
 Topic: Bulk load Fail on DB2 table
joycerecacho

Replies: 1
Views: 86

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 08, 2017 7:24 am   Subject: Bulk load Fail on DB2 table
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi everybody.

I am trying to truncate an DB2 Table and then execute a 'BulkLoad' but I am getting the following error:

DB2_REG_FAT: An error occurred while preparing the table partitioning infor ...
 Topic: Sequence x Job with ParameterSet
joycerecacho

Replies: 7
Views: 663

PostForum: General   Posted: Fri Jun 09, 2017 10:31 am   Subject: Sequence x Job with ParameterSet
Yes, I've already done this kind of Looping Sequence.
The thing is: is it impossible to set manually a parameter of a 'parameter set' to run it throught the Sequence?
 Topic: Sequence x Job with ParameterSet
joycerecacho

Replies: 7
Views: 663

PostForum: General   Posted: Fri Jun 09, 2017 8:03 am   Subject: Sequence x Job with ParameterSet
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everybody!

I'd like to run the same job 12 times (changing only a date parameter) using Sequence job.
I noticed that when I open the job object in the Sequence, it appears only the parameter se ...
 Topic: Resetting Auto-Purge for existing jobs
joycerecacho

Replies: 10
Views: 846

PostForum: General   Posted: Fri Jun 09, 2017 5:13 am   Subject: Resetting Auto-Purge for existing jobs
PaulVL,
Thank you for your suggestion. We are gonna test it here.
I just forgot to mention that the server is Windows.
:/

Thanksss!!
 Topic: Resetting Auto-Purge for existing jobs
joycerecacho

Replies: 10
Views: 846

PostForum: General   Posted: Thu Jun 08, 2017 5:30 am   Subject: Resetting Auto-Purge for existing jobs
Disable refresh in Director, or set it to a very long interval. ...
Ray,
Thank you. It can help a little bit however is just a workaround.
Actually I have difficulty even to open the Director, imag ...
 Topic: Resetting Auto-Purge for existing jobs
joycerecacho

Replies: 10
Views: 846

PostForum: General   Posted: Thu Jun 08, 2017 5:19 am   Subject: Resetting Auto-Purge for existing jobs
Joyceracacho, do you want all jobs to purge after 7 days, or just some?

Yeap! Apply it to all of them!
 Topic: Resetting Auto-Purge for existing jobs
joycerecacho

Replies: 10
Views: 846

PostForum: General   Posted: Tue Jun 06, 2017 9:40 am   Subject: Resetting Auto-Purge for existing jobs
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Additional info: Datastage version 11.5
Hi everybody!!!!

4 years earlier I wrote [url=http://www.dsxchange.com/viewtopic.php?t=150784]this topic...

I am now working for a company where they use Datastage version 11.5 and they are comp ...
 Topic: [Error] Commands out of sync; you can't run this command now
joycerecacho

Replies: 3
Views: 683

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 04, 2016 9:17 am   Subject: [Error] Commands out of sync; you can't run this command now
I need to get a range of data and they are CRM Tables, so I can´t solve this in a normal Lookup, or using Join.
Right?
Cause I thought it would be better to solve this at the BD and not in DataStage ...
 Topic: [Error] Commands out of sync; you can't run this command now
joycerecacho

Replies: 3
Views: 683

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 04, 2016 9:16 am   Subject: Re: [Error] Commands out of sync; you can't run this command
It is worthy mention that I did another test with an integer data type at the WHERE clause and the same error occurred.
 Topic: [Error] Commands out of sync; you can't run this command now
joycerecacho

Replies: 3
Views: 683

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 04, 2016 7:47 am   Subject: [Error] Commands out of sync; you can't run this command now
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everybody.

I am trying to run a Sparse lookup at MySQL Table and it returns the following error:



When I run exactly the same query but not as a reference link but as a stream (a normal se ...
 

 Jump to:   



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