Search found 37 matches
- Fri Dec 10, 2010 8:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate key generator using an Oracle sequence
- Replies: 1
- Views: 3304
Surrogate key generator using an Oracle sequence
Hi Everyone, I am using a surrogate key stage in my job. This is the properties in my surrogate key stage: Database Type - Oracle Oracle Server Name = xxx Password = xxx User Name = xxx Gerarated Ourtpu Column Nam = sk_Facility_ID Source Name = Schema name.sequence name Source Type = Database Sequen...
- Tue Dec 07, 2010 11:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
... which means there are no 'extra' pipes in your file and thus my suggestion should have worked just fine as well. Craig, Yes, my assumption is, there is no extra pipes, if there are extra pipes, there is still a way to get around, this is what I think, step 1. remove all #'s step 2. replace all ...
- Mon Dec 06, 2010 8:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
- Sat Dec 04, 2010 10:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
- Fri Dec 03, 2010 10:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
- Fri Dec 03, 2010 10:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
- Fri Dec 03, 2010 9:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PSV file has quote in the text body
- Replies: 13
- Views: 9034
PSV file has quote in the text body
Good evening everyone, I have a simple parallel job that reads a PSV file, that is, Pipe delimited file with double quotes, here is a sample "aaa"|"bbb"|"ccc"|"dddd" "eeee"|"fffff"|"ggggggg"|"hhhhhhh" but the job skipped...
- Fri Mar 26, 2010 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace in oracle enterprise stage does not work
- Replies: 3
- Views: 2356
Re: Replace in oracle enterprise stage does not work
Hi Everyone, Thank you very much for the suggestions. I have an update on this, I split the job into 2 jobs, the first job writes to a dataset, and the second job reads from the same dataset and load into the Oracle enterprise stage, guess what, no problem. I really don't know why this happens. Hi E...
- Thu Mar 25, 2010 5:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace in oracle enterprise stage does not work
- Replies: 3
- Views: 2356
Replace in oracle enterprise stage does not work
Hi Everyone, Here is a problem, I want to do a destructive load, that is, delete all, then insert, in the oracle enterprise stage, I have Write Method: Load Write Mod=Replace but it does not delete, only inserts. Can anyone let me know why? by the way, I build a server job doing the same thing and t...
- Thu Jan 22, 2009 12:39 pm
- Forum: General
- Topic: Datastage market condition
- Replies: 7
- Views: 3375
- Tue Jan 06, 2009 11:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is Datastage client compatible with linux+wine
- Replies: 1
- Views: 2458
Is Datastage client compatible with linux+wine
Hi Everyone,
I am planning to install datastage client on linux ( ubuntu 8.04 ) with wine. DS server is running on solaris. Has anyone tried this in the past? is Datastage 100% compatible with linux+wine?
Thanks.
I am planning to install datastage client on linux ( ubuntu 8.04 ) with wine. DS server is running on solaris. Has anyone tried this in the past? is Datastage 100% compatible with linux+wine?
Thanks.
- Tue May 06, 2008 6:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSD.SEQOpen An NLS map (ISO8859-2) has been specified,but...
- Replies: 1
- Views: 1599
DSD.SEQOpen An NLS map (ISO8859-2) has been specified,but...
Hi Everyone, I am getting this error message when I run any job in this project, I am also getting this message when I tried to view any sequential file, however, other projects on the same server do not have this problem. Do you know what's going on? Thanks. DSD.SEQOpen An NLS map (ISO8859-2) has b...
- Wed Aug 22, 2007 11:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ftp a csv file with header
- Replies: 1
- Views: 1260
ftp a csv file with header
Hi everyone, I need to ftp a csv file, the delimiter is a #sign, and the file comes with a one line header, and there is no empty row between the header and the body. like this, #header# a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g I am wondering, is there any ...
- Tue Aug 22, 2006 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple links to the same file in one job
- Replies: 6
- Views: 2235
multiple links to the same file in one job
Good morning everybody,
I need to have multiple links writing to the same target, the target could be a sequential file, afileset or a dataset. is there anyway I can do it without using a funnel stage?
I need to have multiple links writing to the same target, the target could be a sequential file, afileset or a dataset. is there anyway I can do it without using a funnel stage?
- Mon Aug 14, 2006 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row too big for inter stage rowbuffer
- Replies: 6
- Views: 4189
The entire file has more than 2 million characters. I use an xml input stage, and the xml source is 'xml document'. I saw your message earlier this morning , so I changed the source to 'url/file path', But I am still getting the same error message. This is the error message: FBuilder_DTD_test.#0.get...