Search found 32 matches

by vilasini
Tue Sep 30, 2008 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Separte all duplicate records
Replies: 11
Views: 6691

Please provide how did you resolve it.It will help for others.
by vilasini
Tue Aug 05, 2008 5:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check for an Integer and null
Replies: 6
Views: 2965

I have used NOT(IsNull(AsInteger(inputfiled)))
by vilasini
Wed May 28, 2008 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job get locked
Replies: 3
Views: 1788

I think you do not have access to logout the jobs.You can kill the process in unix box by taking the PID of that particular job.
by vilasini
Thu May 08, 2008 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert string to timestamp am or pm
Replies: 20
Views: 7642

I have resolved it by checking with '/' of each and every combination of timestamp.I have defined 6 stage variables to convert.I cann't post variable derivation as it is very long.
I hope we can write a routine for that too.
Thanks
by vilasini
Fri Apr 04, 2008 10:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 6477

Ok.Thanks a lot.
by vilasini
Fri Apr 04, 2008 9:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 6477

Thanks abburi.Vista aupports is any other version of datastage.
by vilasini
Fri Apr 04, 2008 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 6477

Installing Datastage

Hi Friends,

I wanted to install datastage 7.5x2.
I have Windows Vista in my system.Any one can suggeest me can I install datastage on Vista and what and all are required before installing.

Thanks in Advance
Anju
by vilasini
Tue Mar 04, 2008 4:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: newline character
Replies: 13
Views: 5504

Thanks a lot.Its working now.I used char(10).
by vilasini
Tue Mar 04, 2008 3:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: newline character
Replies: 13
Views: 5504

Hi ArndW,
my frontend is Wincdows for datastage and backend is Unix.
I dont have an idea how to put a newline using CR /LF in datastage.Can you tell me how to do that.
by vilasini
Tue Mar 04, 2008 3:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: newline character
Replies: 13
Views: 5504

ok.
my frontend is Wincdows for datastage and backend is Unix.
I dont have an idea how to put a newline using CR /LF in datastage.Can you tell me how to do that.
by vilasini
Tue Mar 04, 2008 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: newline character
Replies: 13
Views: 5504

Hi Ray, I can view your answer till "Create a stage variable, let's call it svNewLine. In Windows, of course, the line terminator is actually two characters (carriage return and line feed), so initialize the stage variable to Code:" till here,can you explain me again how to get newline. Th...
by vilasini
Tue Mar 04, 2008 1:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: newline character
Replies: 13
Views: 5504

newline character

Hi,

I need to concatenate some text + newline(\n) + <input field>.
Can any one help how to add newline between some text and input field.

Thanks
Anju
by vilasini
Mon Feb 25, 2008 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: import error and no default value
Replies: 9
Views: 5582

Hi Ray,

I have posted the records inside the file.I dont know what and how it generates the OSH record schema to post.Can plz you tell me how I can get the record schema.

Thanks
by vilasini
Sun Feb 24, 2008 11:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: import error and no default value
Replies: 9
Views: 5582

I have the file like this
"DUMMY_CONTACT","EMPLOYEEMAX_CONTACT_ID"
"1","126"

It will always be one record as it hold only max number and it shows the 2nd field name.

Thansk in Advance...
by vilasini
Fri Feb 22, 2008 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: import error and no default value
Replies: 9
Views: 5582

No,I have only one record which is
"1","126" and it always be one record.