Search found 78 matches

by jusami25
Tue May 05, 2009 2:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link keeps black
Replies: 15
Views: 6213

Hi,

I forgot to clarify that it's not a multiple instance job.

regards.
by jusami25
Tue May 05, 2009 1:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link keeps black
Replies: 15
Views: 6213

Hi,

the stage types are:

Dataset ------> Remove Duplicates ---------> Oracle (Green link)


Dataset ------------------------------------------> Oracle (Black link)

No containers involved. The job works as expected. But no statistics are shown por the Dataset to Oracle link.
by jusami25
Fri May 01, 2009 3:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link keeps black
Replies: 15
Views: 6213

Yes it's still active, but the colors and the number of rows are not displayed. However te job seems to work fine.


We just have to know what is causing this behaviour, because from time to time it's happening.


Thanks a lot for your help
by jusami25
Thu Apr 30, 2009 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link keeps black
Replies: 15
Views: 6213

Link keeps black

Hi all, Normally when you run a job (on the designer) the links changes their colours between black, blue, green, red. We have one job that during and after the execution the links are allways black. The job finish successfully and the records gets the target stage. Do you know how to see the links ...
by jusami25
Wed Apr 29, 2009 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compile jobs on a specific category
Replies: 7
Views: 4426

compile jobs on a specific category

Hi all, I'm trying to compile all the jobs of a specific folder using the command dscc. dscc /h HostName /u User /p Password /j /jobs/Folder/* Project The problem is that the command compiles all the jobs in the project and not the ones that are placed on the /jobs/Folder/ Any suggestion? Thanks in ...
by jusami25
Fri Apr 03, 2009 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot get output from DSExecute
Replies: 6
Views: 1571

Hi DSguru2B,

same result (nothing) returned :cry: in Windows platform. We have tried to do it on Unix server and it works fine... As you said is Strange :?

By the way, we have done a work aroud (redirect the output to a file), read the file and return the information stored in the file.
by jusami25
Thu Apr 02, 2009 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot get output from DSExecute
Replies: 6
Views: 1571

test.txt has:

100 records
by jusami25
Wed Apr 01, 2009 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Dataset to Oracle
Replies: 6
Views: 2296

Sure chulett.

I will keep the forum updated :wink:
by jusami25
Wed Apr 01, 2009 2:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot get output from DSExecute
Replies: 6
Views: 1571

Hi DSguru2B,

we had the blank space (sorry I wrote the topic with out it)

Code: Select all

CALL DSExecute ( "NT", "dsrecords ":PathDataset, Output, RetCode ) 
[/code]
by jusami25
Tue Mar 31, 2009 11:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Dataset to Oracle
Replies: 6
Views: 2296

Hi,

I have found a on this topic a posible solution of the bug... viewtopic.php?t=119030&highlight=Job+Ab ... e+of+nodes
by jusami25
Tue Mar 31, 2009 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot get output from DSExecute
Replies: 6
Views: 1571

Cannot get output from DSExecute

Hi all, we are using below server routine to get the number of records of a dataset: CALL DSExecute ( "NT", "dsrecords":PathDataset, Output, RetCode ) If RetCode = 0 Then Ans = Output End Else Ans = "ERROR" End But we are not getting the number of records as Output... I...
by jusami25
Tue Mar 31, 2009 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Dataset to Oracle
Replies: 6
Views: 2296

Hi Richdhan,

Thanks for the reply. We have thought the same solution you provide.

As this error seems to be an IBM bug. What we want to know is:

There is anyone who have faced the same problem?
There is an IBM patch to solve this?

Thanks.
by jusami25
Thu Mar 26, 2009 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copy rows based on input column value!
Replies: 7
Views: 2610

Hi, he had the same requeriment and we solved it with two jobs: First job Input Record --> KEY, COUNT Seq File --> Transform -- Seq File On the Transfrom job we use the Str() function in this way: If InputLink.COUNT > 0 Then InputLink.KEY : ',' : InputLink.COUNT: ',' : Str(Char(10) : InputLink.KEY :...
by jusami25
Thu Feb 26, 2009 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Know current users working
Replies: 7
Views: 1435

Hi Mike,

Yes I selected "Show All" under processes, but I just can see allways the same user :(

Thanks again.
by jusami25
Thu Feb 26, 2009 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle table definitions got multiplied by 3
Replies: 5
Views: 2260

Hi, we have seen a configuration parameter in Oracle Database ( nls_length_semantics ) which have been set as byte and can have be set as char value. Do you think this can solve the issue? We have not tried to change the value yet because we cannot update oracle configuration due to another project ...