DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 270 matches
Author Message
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Tue Jan 30, 2018 1:13 pm   Subject: dscmdexport domain?
Tried, but failed.
:/
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Sat Jan 27, 2018 4:47 am   Subject: dscmdexport domain?
Sorry, my fault.
I was talking about the dsjob command.
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Wed Jan 24, 2018 3:24 pm   Subject: dscmdexport domain?
Guys!

The dscmdexport worked!
Actually it was not necessary the domain, only the host.
Since we are working in a Cloud environment, i just informed the wrong value for host. My fault!
:/

But ...
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Wed Jan 24, 2018 2:34 pm   Subject: dscmdexport domain?
Thank you guys.

And to list the project names using the dsjob from the client tier, it should work fine, right?

I am trying and getting the following error:

"Last recorded error message =
ja ...
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Wed Jan 24, 2018 11:24 am   Subject: Re: dscmdexport domain?
Guys,

Do you have any suggestion about backing up all projects in DataStage?
Once I developed a .bat script to that, which worked perfectly in another company, with Windows Server and a later vers ...
 Topic: dscmdexport domain?
joycerecacho

Replies: 11
Views: 644

PostForum: General   Posted: Wed Jan 24, 2018 7:13 am   Subject: dscmdexport domain?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi everybody!

I am having the same issue [url=www.dsxchange.com/viewtopic.php?t=157547]as this post but I am trying to figure out what is the websphere domain to inform at the command.

Can anyon ...
 Topic: NLS Configuration - Oracle character set to '?'
joycerecacho

Replies: 7
Views: 1386

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: 1386

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: 1386

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: 1386

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: 1386

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: 346

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: 1335

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: 1335

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: 1637

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

 Jump to:   



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