DSXchange

Hi,

Are you using Job Mainframe?

In the Job Mainframe constraint you must to define the next conversion

CAST(Campo AS DECIMAL(18, 4) ).

Hi, If your input is a sequential file you can use stages variables. Define in the transformer stage: Dupli = If (LastField = ActualField) Then 1 Else 0 LastField = If (LastField <> ActualField) Then ActualField Else LastField In the constraint you define the next condition Dupli = 0 In the output f...

Hi Raj, You must to considerate 2 items: 1) Read all records using 1 query 2) Use partitioned query using key ranges Depending the choice you will have: 1) The Array size to define will have to be a value that allows to read the greater record number without degrading the process throughout. 2) To c...

Hi, the other way is use substrings

Your format --> 'YYYY-MM-DD'

Value = DateField[2,8]

Example:

'1999-04-02' applying DateField[2,8]

Value='99-04-02'

Saludos.

Hi Forum, I running a job that obtain the max of a field, i use an Agregator, are three numeric fields (integers, total length is 12) I define the 2 fields agrouped and the third is the max, my question is ... If this is the jcl template for the sort definition ... //********************************...

Hi, Another way is create a query that contain almost lookups that you need. >For example: select cod_cli, cod_cta, cod_tip from client_table select cod_tip, des_tip from cat_tip in your query join both tables: select a.cod_cli, a.cod_cta, a.cod_tip, b.des_tip from client_table a, cat_tip b where a....

Hi Ray

But in the documentation say that stages (Join and Lookup) use one stage to the dataset and other stage to table but dont say it can be use to join 2 datasets ...

So, i will try with the join stage.

Thanks.

Hi,

How use a Job Mainframe to make a search between 2 datasets. ..

DataSet1
|
| (search) ---> DataSet Output
|
--> DataSet2

What stage is recommended to make this.



Thanks.

Hi

THis is a last post in the forum,

viewtopic.php?t=85440&highlight=condition+lines

Hi Yiming,

What kind of database use???

Can you explain how is and work your job ???

Hi forumers ....

With the next UNIX command obtain the number of jobs:

> dsjob -ljobs MyProject | wc -l

But the result is only the server jobs ...

How obtain the total number of jobs in my project (server and mainframe) ?????

Hi Zam

In the jobname you add the '.' and the Identificacion of the instance

> dsjob -run -mode NORMAL -warn 0 -rows 0 MyProject MyJob.Id
(where Id is the variable part)

Hi Pinkesh,

In your job you can define 2 links, in the first link use as constraint INROWNUM < 100000 and the second INROWNUM > 100000

(These values are referencials, you have to define the real range)

After, you can use both files as input to the other process.

Hi Peter

If the user belongs to a group defined as Developer you dont have be problems.

Check if you have the adequate permissions to invoke the at and cron commands in UNIX.

Hi Pinkesh

You can use the unix sort is more eficient than the datastage sort ...

In the unix command you can redefine the temporary area sort with the option -T

> sort -T /home/temp ......

:D