Search found 106 matches
- Wed Jan 17, 2018 2:25 pm
- Forum: General
- Topic: Client requested protocol TLSv1 not enabled or not supported
- Replies: 9
- Views: 12291
Hi had a similar issue when trying to call the Microsoft Dynamics 365 API on DS 11.3 fp1 recently... Microsoft disabled support for TLS1, which is perfectly understandable! I did not need to apply a patch, we just upgraded the JDK and added the following line to the Hierarchical Stage properties: -D...
- Wed Sep 13, 2017 5:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handling Nulls for decimal fields in transformer stage
- Replies: 2
- Views: 4617
Are your decimal columns nullable in both of the Input links of your Join Stage ? If you have defined your decimal columns as non-nullable in DataStage, I think it will default the NULLs to 0 ? Also, you may prefer to use the NullToEmpty() function instead of the If IsNull() Then '' .. Else ... synt...
- Tue Sep 12, 2017 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 11966
It is failing because on of the target columns is VARCHAR(20) . VARCHAR(20 byte) or VARCHAR(20 char) ? https://stackoverflow.com/questions/81448/difference-between-byte-and-char-in-column-datatypes What happens if alter your target column to VARCHAR(20 char) ? If you need to data type convert with ...
- Thu Sep 07, 2017 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Stage with just REJECT link
- Replies: 3
- Views: 5850
- Wed Sep 06, 2017 5:55 pm
- Forum: General
- Topic: Paramètre entre job
- Replies: 2
- Views: 3116
Salut Franck, Where do you store the date you've retrieved from job 1 ? Try the following (there are other approaches, but I find this one to be the easiest to get right) - In job 1, write your date into a flat file, eg. param.txt Now your Job sequence should look like this: Job 1 ---> Execute Comma...
- Tue Jun 13, 2017 4:42 pm
- Forum: General
- Topic: put a 15 minute delay in the next execution of a start loop
- Replies: 4
- Views: 4000
- Tue Jun 13, 2017 4:03 pm
- Forum: General
- Topic: Running jobs in parallel
- Replies: 11
- Views: 7037
Example of a Job sequence that allows us to load up-to 10 tables at the same time (250+ tables) http://i.imgur.com/UEp0Wc2.png First job just creates 10 flat files for looping through list of tables.. You don't need this. How about you try something like what is in the green square ? (Sequencer set ...
- Tue May 09, 2017 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 9
- Views: 6940
Personally, I was able to have an understanding of Conductor/Section leaders/Players, only after reading the last chapter of Ray Wurlod's white paper:
http://dsxchange.net/uploads/White_Pape ... aStage.pdf
http://dsxchange.net/uploads/White_Pape ... aStage.pdf
- Tue May 09, 2017 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing Rejected data columns in to reject file using RCP
- Replies: 8
- Views: 7185
- Wed May 03, 2017 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read .aspx file using datastage
- Replies: 7
- Views: 9654
- Tue May 02, 2017 5:23 pm
- Forum: General
- Topic: Azure SQL connectivity from DataStage.
- Replies: 1
- Views: 8569
Re: Azure SQL connectivity from DataStage.
According to almighty Google when you search for "Cannot load trust store" , it seems you have stuff missing in your odbc.ini file eg. from the first 2 search results: Add the following connection options to the SQL Server DSN in the odbc.ini file EncryptionMethod=1 TrustStore=xxxxx TrustS...
- Wed Mar 15, 2017 2:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting columns to rows
- Replies: 4
- Views: 3784
Or this
Could easily be done using the Pivot Stage.
Could easily be done using the Pivot Stage.
- Wed Mar 15, 2017 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File Connector, Big Data Stages - BigInsights compatibility
- Replies: 4
- Views: 5109
Re: File Connector, Big Data Stages - BigInsights compatibil
And that just to say you don't need to ensure access to the shared library. At least that's how I'm reading it.? Yes, you're right. But anyway, the mystery remains for now: To access a Hadoop Distributed File System (HDFS) with the Big Data File stage , you must make the libhdfs.so [...] I understa...
- Mon Nov 07, 2016 2:26 pm
- Forum: General
- Topic: Job Sequence checkpoints - When are they lost ?
- Replies: 3
- Views: 3874
- Sun Nov 06, 2016 8:47 pm
- Forum: General
- Topic: Job Sequence checkpoints - When are they lost ?
- Replies: 3
- Views: 3874
Job Sequence checkpoints - When are they lost ?
Hi, Let's say that: - I stop a running but restartable Job Sequence (checkpoints enabled for each of its step) from the Director client. - Then shut down the Engine server. - Then shut down the Unix machine - After a few hours, I restart the Unix server and the Engine server .... Questions: 1) When ...