Search found 143 matches

by devesh_ssingh
Mon Jan 10, 2011 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spaces error at sequence level
Replies: 12
Views: 4984

Thanks craig for making correction....
may i have any i/p to solution???
i m stuck... :evil:

Recently i have removed APT_PAD_CHAR at job level and used on sequence level...
then also appering same issue....
by devesh_ssingh
Mon Jan 10, 2011 5:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spaces error at sequence level
Replies: 12
Views: 4984

the op1 is not propely appering

it have huge space between columns, somehow its appering incorrect!!!
by devesh_ssingh
Mon Jan 10, 2011 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spaces error at sequence level
Replies: 12
Views: 4984

Spaces error at sequence level

Hi Mentors, i have one sequence attached with several job like job1--->job2---->job3---->job4--->job5 there is no abosolute depedency between these jobs. only it shuld be run one after on like after job1 then job2 then job 3 now problem is when i run this sequence and when check o/p of job4 it produ...
by devesh_ssingh
Tue Jan 04, 2011 10:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric data type
Replies: 5
Views: 2053

can you be more specific abt ur requirment ...rather than error
by devesh_ssingh
Tue Jan 04, 2011 5:44 am
Forum: General
Topic: usage of system variable??
Replies: 2
Views: 1470

check the DS help pdf...you will find required info.... :D
by devesh_ssingh
Thu Nov 04, 2010 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic required
Replies: 6
Views: 4244

logic required

Hi I have an requirment seems to be simple but stuck up with logic. its like i/p: col1 col2 col3 col4(date) col5(date) col6 a b c 2010-10-20 9999-12-31 e a b c 2010-10-21 9999-12-31 e a b c 2010-10-22 9999-12-31 e a b c 2010-10-23 9999-12-31 e o/p1: col1 col2 col3 col4(date) col5(date) col6 a b c 20...
by devesh_ssingh
Mon Oct 18, 2010 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert varbinary to varchar
Replies: 0
Views: 1036

convert varbinary to varchar

Hi All,

I am facing a problem
i have source file have one column is of Data type varbinary,
now i want to read it in to varchar in target having 80 column byte by byte

i have serached this topic but did not get concrete answers.

i am looking for help on this.


Thanks and regards,
Devesh
by devesh_ssingh
Thu Aug 05, 2010 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Upsert Error while trying to Update and Insert
Replies: 8
Views: 4891

you cannot insert record in child table without having its corresponding parent records..its violation of foreign key constraint.
try inserting such record in child who have corresponding record...
foreign key of child table linked to primary key of parent table...
by devesh_ssingh
Fri Jul 23, 2010 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer logic
Replies: 8
Views: 4598

subject gone in other direction

i meant when i put my card information...the CVV number is visible. as in its not encrypted...whenever i have used my card CVV num was encrypted.....
hence scared :(

is it safe to do online transcation here....cause i need to upgrade my membership....
please suggest
by devesh_ssingh
Sat Jul 17, 2010 4:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer logic
Replies: 8
Views: 4598

Hi ray,

i didnot found online payment safe....other option of payment is outa of question...
by devesh_ssingh
Thu Jul 15, 2010 9:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get rid of COBOL levels in datastage Data Set column defs?
Replies: 15
Views: 15846

Frankline.. i did not get you...you mean to edit copy book and re import....if you do so then how would you read the data as its still in cobol format.... i'll add one more point from my experince ...even if u do some opertaion carrying level name if it changes in between then too its generate error...
by devesh_ssingh
Thu Jul 15, 2010 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer logic
Replies: 8
Views: 4598

thanks for response
i got first one but could not see the other as it is hiding
by devesh_ssingh
Thu Jul 15, 2010 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer logic
Replies: 8
Views: 4598

transformer logic

Hi, i have a 2 requirements 1) i/p o/p a a b b c c 1 01 2 02 3 03 4 04 5 05 6 06 7 07 8 08 9 09 10 10 i have declared stage variable and wrote if else like below... if col=1 or col=2 or col=3 or col=4 or col=5 or col=6 or col=7 or col=8 or col=9 then 0||col else col... then used this variable in der...
by devesh_ssingh
Thu Jun 24, 2010 2:49 am
Forum: DSXchange Testimonials
Topic: Thanks Ray - 40000+ posts!
Replies: 3
Views: 19117

Thats absolutely incredible.....

Hail Ray!!!!
by devesh_ssingh
Thu Jun 24, 2010 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to read selected rows using sequential file
Replies: 8
Views: 3335

do you required to build such a job ...?
in such case ....
just put constraint whatever you need to read
or from source file you want to read only those records?

user command
grep 10 filename

hope it will solve your problem