DSXchange

Hi, I have Datastage PX 6.0 I understand that jons reside in dir $dshome/Projects/. -Can I access my jobs from this dir? -How do I compile jobs from UNIX prompt? -If so, then can I compile multiple (or all) jobs in one project using a single command/ script? Thanks in advance for a prompt reply. Reg...

Hi Mat,

Thanks for your reply.

Bingo!
You got our problem right.

Could you pls give the further details on the resolution for this.
Also would you like to share the subroutines you used for this purpose.

Thanks.
Regards,
Nitin

PX 6.0:- We prepared a sequencer which internal calls 5 PX jobs. Whenever a job is complete status other "warning" and "ok" we stop calling next jobs from that sequence. This works fine. There are such 4 sequencers in all. All these 4 sequencers are called from a main sequencer. ...

Hi,

I have PX 6.0.

How to generate a an alphanumeric seq in a job?
for eg:-
Requirement1
-AA
-AB
-AC
-AD

Requirement2 (alphabets concated with a range of numbers, say till 3)
-AA1
-AA2
-AA3
-AB1
-AB2
-AB3..

Please reply asap.

Thanks.
Nitin

Hi, I have a Parallel job in PX 6.0. It has one dataset providing input data to a transformer. I obtain multiple (around 10) datsets as output from transformer. This jobs runs indefintely. When the DSEngine is brough down adn brought up again it works good. Otherwise again after some days this hangs...

Hi,

I need current dates in different formats vizz

-YYMMDD
-YYYYMMDD

Which are the functions available I can use for this in a transformer.

I am using PX 6.0, DS Designer ver 6.0.0.17.

Any pointers are most welcome.

Thanks in advance.
Regards,
Nitin

Hi, I dont know why but I cant find the firts/ last aggregation function in the sub-properties in aggregator stage. It only has MIN and MAX options, however those seem to be working for numeric fields only and not for char fields. Is this probably not avbl in ther version I have? I am using PX ver 6...

Hi, How do we pick first/ last CHAR value, based on a key, For e.g. :- If my input data is,say: key----fld2---fld3 X------"AA"---"MEM" X------"CC"---"SEC" X------"BB"---"CPU" Y------"SS"---"BIT" Y------"TT"---&...

Thanks Teej, that certainly helped.

Thanks to all of you for those inputs.

Regards,
Nitin

Based on the ongoing discussion, I have certain related questions: -When we talk of transformer, there is no key like thing isnt it. So where does the question of two records being same come in here. Is it something related to the dataset? I even tried having the sequential file as output from trans...

I understand Kenneth. I will try to be more explicit now.. -partitioning scheme: It is set to 'Auto' in all prior stages in that job. Data sets being used are set with Preserve partitioning = 'Default (Propagate)'. -Job Nodes Pools: 4 nodes i.e. 4x4 No, I am not switiching node pools in between. I a...

Kim,

My source and target stages are simply Data Sets (or a Lookup stage).

I am not using any ODBC, or any database calls for the jobs in question.

As I said I am not getting any warning messages corresponding to the transformer in the log file.

Data Stage is PX 6.0.

[?]

Regards,
Nitin

Okay further details are as below: Source Stage: Dataset (or an output stream from a previous lookup stage) Target stage: DataSet I am viewing the number of records flowing through each link using either of the following: -'Show performance statistics' Option -(job) Monitor Both essentially give the...

Hi,

I have a transfomer stage which has 'x' # of rows in input stream.
There is no constraint on the transformer.

Even then, the output is 'y' # of rows where y < x.

There are no corresponding warnings/messages in the log file.

Any pointers to this?

Thanks in advance.

Regards,
Nitin

What is the simplest way of converting smallint/integer to string?

Regards,
Nitin