Search found 103 matches

by Prashantoncyber
Thu Jun 16, 2005 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting No in Nullable Column
Replies: 7
Views: 3618

Srinivas

wht if i want to pass those values also with out rejecting.....then ?


Thanks

Prashant
by Prashantoncyber
Thu Jun 16, 2005 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting No in Nullable Column
Replies: 7
Views: 3618

Setting No in Nullable Column

Hi All, I getting following warning Sequential_File_3: When checking operator: When validating export schema: At field "Time": Exporting nullable field without null handling properties when Nullable Column is set Yes. However, this warning goes off when when I change Nullable from yes to N...
by Prashantoncyber
Thu Jun 16, 2005 3:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning
Replies: 5
Views: 1878

Warning

Hi All, I am getting following warning Sequential_File_4,0: Field "job_lvl" has import error and no default value; data: {j o b _ l v l}, at offset: 40 Job is very simple just loading the data from sequential file to another seq file while appending some column in between at Transfermormer...
by Prashantoncyber
Wed Jun 15, 2005 4:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: joining datasets
Replies: 5
Views: 2645

hi,

you can append a dummy colum in each table using transferformer to create data like this

Table 1

A B Dummy Column
1 2 X
1 4 X


Table 2

A C Dummy Column
1 2 X
1 4 X

now use join Stage subsequently to get the desired result using Dummy
column as key.

Thanks
Prashant
by Prashantoncyber
Sun Jun 12, 2005 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix Servers
Replies: 2
Views: 1147

Thanks Chullet
by Prashantoncyber
Sun Jun 12, 2005 6:25 am
Forum: DSXchange Testimonials
Topic: Great Work
Replies: 10
Views: 42195

ya, I has become lifeline for developer like me.

thanks to everybody.
Prashant
by Prashantoncyber
Sun Jun 12, 2005 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix Servers
Replies: 2
Views: 1147

Unix Servers

can any body tell,

What is difference between

Unix servers with SAMBA and other unix servers?

thanks

Prahant
by Prashantoncyber
Sun Jun 05, 2005 4:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Counting No Of Lines
Replies: 10
Views: 3644

Sainath,

Wht should be commands if there is Blank spaces in line and we dont want to count them as well?

thanks
Prashant
by Prashantoncyber
Thu Jun 02, 2005 2:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine for writing Log to Sequential file
Replies: 2
Views: 1047

Routine for writing Log to Sequential file

I ran the below routine which writes logs to Sequential somewhere picked up from this forum. But it is just writing very fews logs instead of whole logs. Pls guide what changes are required in this routine to get whole log written to sequential file. Thanks Prashant $IFNDEF JOBCONTROL.H $INCLUDE DSI...
by Prashantoncyber
Thu Jun 02, 2005 1:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rename the Job Category
Replies: 4
Views: 1517

If you want to avoid dsx implications as well as speed up moving of jobs from one category to another can be done just by select ctl+A of all the jobs in Manager and move it to new category instead doing one by one from designer.
by Prashantoncyber
Wed Jun 01, 2005 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal errors in running the job
Replies: 2
Views: 2298

Fatal errors in running the job

Hi all, when i am running the job its aborting giving the following two fatal errors- main_program: APT_CountReducer: field account_id is already present in the output interface schema. main_program: Fatal Error: setOutputSchema() was not called in APT_CountReducer::describeReducer(). when is sequen...
by Prashantoncyber
Wed Jun 01, 2005 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job is locked while creating the copy
Replies: 3
Views: 1212

Try this command from Administrator UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NAME = '<Job Name>'; Regards Hexa Hi Hexa, when i executed this command from Administrator, It says that 1 reacord is updated. Subsequently , my problem is resolved. Can you give some insight how what this command do...
by Prashantoncyber
Wed Jun 01, 2005 11:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job is locked while creating the copy
Replies: 3
Views: 1212

job is locked while creating the copy

Hi All

I can open the job sccessfully.

But When i am trying to create the copy of job its telling

that job is locked. I wondering about this scenario.

thanks

Prashant
by Prashantoncyber
Mon May 23, 2005 2:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to generate a calendar Year Using DataStage
Replies: 12
Views: 9106

How to make dynamic both ways ie start date as well as end date?
by Prashantoncyber
Mon May 23, 2005 12:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does ODBC query gets killed, when your reset a Job
Replies: 6
Views: 1714

Is there any way that we can find it out wether querry is running or not either thro' DS or Orcle DB?