Search found 5 matches

by georgheretis
Wed Aug 28, 2013 11:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: null value on the accessor interfacing to field Id
Replies: 1
Views: 1772

null value on the accessor interfacing to field Id

I have this fatal error when I am trying to run a job. How can I solve the problem. Thanks in advance
by georgheretis
Fri Aug 02, 2013 2:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: remove zero and a point from nvarchar
Replies: 2
Views: 3120

remove zero and a point from nvarchar

Goodmorning. I have a field Nvarchar with length 450. My data is in the form 00000000000000000140. (20 characters including the point (.). I would like to remove all zeros and the point at the end and keep only the 140. If the case is 0000000000000000000. , I need to have 0. Thanks
by georgheretis
Fri Nov 02, 2012 4:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove delimiter (;) from the end of a csv file
Replies: 5
Views: 3164

Due to the fact that I am using only one transformation stage , is it possible to use the 'replace' or something else in order to remove the delimiter
by georgheretis
Fri Nov 02, 2012 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove delimiter (;) from the end of a csv file
Replies: 5
Views: 3164

How to remove delimiter (;) from the end of a csv file

How to remove delimiter (;) from the end of a csv file , when the csv file is a source. I need to do for a field in a transfrormation in order to remove the delimiter at the end.
by georgheretis
Wed Oct 24, 2012 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error in director
Replies: 1
Views: 1363

error in director

Hello I have a problem running a job and the following error was appearead in director: /IA_IT/ia_datasets/EXT_Ifilename. ds: Data set initialization for "/IA_IT/ia_datasets/EXT_filename.ds": This input-file data set does not exist: /IA_IT/ia_datasets/EXT_filename.ds. the source is a scv f...