DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 999 matches
Author Message
 Topic: Generate sequence number using parallel job
Mike

Replies: 6
Views: 215

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 21, 2017 7:08 am   Subject: Generate sequence number using parallel job
Did you use round robin partitioning method?

Mike
 Topic: code version check
Mike

Replies: 4
Views: 123

PostForum: General   Posted: Tue Jun 20, 2017 6:45 pm   Subject: code version check
I've gone with a 2 step approach for identifying version change candidates.

Step 1 is to compare the modification timestamps using XMETA. These are the same modification timestamps that you would s ...
 Topic: Unable to find Java Technology Edition software
Mike

Replies: 2
Views: 93

PostForum: General   Posted: Fri Jun 16, 2017 7:28 am   Subject: Unable to find Java Technology Edition software
I haven't done an 11.5 install yet, but for all other versions that I have installed the required IBM java is part of the installation package. You just have to follow the installation instructions an ...
Resolved
 Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
Mike

Replies: 13
Views: 333

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 15, 2017 9:41 am   Subject: Fatal Error: Attempt to setIsNull() on the accessor interfac
Nice job of narrowing down the cause.

It's good to know that a failed cast function in the ODBC Connector results in NULL.

You mentioned AS400, so is your underlying database DB2?

Mike
Resolved
 Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
Mike

Replies: 13
Views: 333

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 14, 2017 7:47 am   Subject: Fatal Error: Attempt to setIsNull() on the accessor interfac
Unfortunately the report of schemas generally gets lost when the job aborts.

1) Verify that you have no column metadata defined in the ODBC connector.
2) Verify that the sql select statement doesn ...
 Topic: Sequence x Job with ParameterSet
Mike

Replies: 7
Views: 197

PostForum: General   Posted: Fri Jun 09, 2017 1:44 pm   Subject: Sequence x Job with ParameterSet
Unfortunately the job activity is lacking in flexibility when it comes to parameter sets. You are essentially stuck with 3 options: choose "As Predefined", choose a values file name from the drop-down ...
Resolved
 Topic: Handling non English characters while using substring
Mike

Replies: 6
Views: 234

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 07, 2017 8:11 am   Subject: Handling non English characters while using substring
As you see, bytes and characters have a variable ratio when you are dealing with UTF8. Characters will range in size from 1 to 4 bytes. Your 30 byte column in Oracle could potentially hold as few as 7 ...
Resolved
 Topic: Handling non English characters while using substring
Mike

Replies: 6
Views: 234

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 07, 2017 6:36 am   Subject: Handling non English characters while using substring
UTF8 and bounded varchars come with the sort of baggage that you're seeing. That's due to UTF8 having a variable number of bytes per character. You should switch to nvarchar (or the equivalent of addi ...
Resolved
 Topic: Accessing IE during Information Server installation on Linux
Mike

Replies: 5
Views: 223

PostForum: General   Posted: Sat Jun 03, 2017 5:36 pm   Subject: Accessing IE during Information Server installation on Linux
If you want to use the Internet Explorer browser for installing on Linux, you'll be running it on a remote Windows computer. You can of course choose to use a browser on the local Linux computer, but ...
 Topic: Filter through Complex Flat file stage
Mike

Replies: 3
Views: 215

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 02, 2017 12:19 pm   Subject: Filter through Complex Flat file stage
That filter option is where you would put a UNIX command to operate on your file (not going to be much use on a binary file).

You could use a transformer constraint after the CFF stage.

The cons ...
 Topic: Datastage command using dsjob -ljobs does not display jobs
Mike

Replies: 18
Views: 613

PostForum: General   Posted: Fri Jun 02, 2017 7:16 am   Subject: Datastage command using dsjob -ljobs does not display jobs
projectname will be case sensitive. Make sure you are matching case exactly and make sure that projectname does not contain any non-display characters.

See what this gives you:
dsjob -lprojects 2& ...
Resolved
 Topic: Field seperator
Mike

Replies: 6
Views: 282

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 01, 2017 3:51 pm   Subject: Field seperator
Look in appendix B of the parallel job developer's guide for all of the transform functions available. String functions would have options for you: DCount, Index, Field, [].

It would be good to bec ...
 Topic: Admin Access
Mike

Replies: 7
Views: 351

PostForum: General   Posted: Fri May 26, 2017 7:28 am   Subject: Admin Access
Forgot to add when i log in to DS Admin, i cant seepermissions tab enabled for the project which was manually assigned to me in DS admin

This tells me that the ID that you logged in with does not h ...
 Topic: Capturing Rejected data columns in to reject file using RCP
Mike

Replies: 8
Views: 733

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 25, 2017 1:53 pm   Subject: Capturing Rejected data columns in to reject file using RCP
What did your official support provider have to say?

It sounds to me like it's either a limitation of the reject link for the Oracle Connector or a bug.

Mike
 Topic: Can I use RCP for a multi table select
Mike

Replies: 1
Views: 212

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 25, 2017 1:48 pm   Subject: Can I use RCP for a multi table select
Yes. It's not all that different from a single table SELECT. However, you will have to provide the SELECT statement rather than having the stage generate the SQL. Provide the SELECT statement with a j ...
 

 Jump to:   



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