Search found 4 matches

by franek
Mon Aug 28, 2017 4:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading 1252 fixed length file into UTF-8 DB2 - DB2CODEPAGE
Replies: 2
Views: 4203

Re: Loading 1252 fixed length file into UTF-8 DB2 - DB2CODEP

I did test with Data Set - NLS in job and sequential file is 1252 - When I use View Data... in Data Set, accents are visible and all columns are loaded properly. But in debug, these characters are still as '?'. When I replaced Data Set with DB2 Connector, and left table as it was (with varchar), the...
by franek
Sun Aug 27, 2017 5:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading 1252 fixed length file into UTF-8 DB2 - DB2CODEPAGE
Replies: 2
Views: 4203

Loading 1252 fixed length file into UTF-8 DB2 - DB2CODEPAGE

I have set of jobs, that weren't supporting national characters, and now I have to load files with 1252 codepage. My target database is DB2 with UTF-8 - I checked it and I am able to insert e.g. characters with accents. I'm thinking how to adjust my DS jobs with minimum effort. To simplify, job desi...
by franek
Fri Jul 14, 2017 10:07 am
Forum: General
Topic: Design of independent parallel sequences
Replies: 0
Views: 2221

Design of independent parallel sequences

I have multiple sequences that looks like this (let's call it SimpleSequence): WaitForFile -> JobActivity(parallel) -> ExecuteCommandActivity -> JobActivity(parallel) What I want to achieve: Those jobs concern one functional area and I want to schedule them once. To avoid scheduling each job I have ...
by franek
Wed Jul 05, 2017 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Integration stage makes job fail with 262276 code
Replies: 0
Views: 2734

Java Integration stage makes job fail with 262276 code

First, I want to say hello to all of you! I'm new in Data Stage, previously I was working with MS SSIS. Here is my problem: I am trying to run some Java code in Java Integration stage. To get some training I wanted to use code from IBM website. I compiled this code with Java 1.6, succesfully set cla...