DSXchange

When you are logging into the system, are you logging with omit option.
If yes then try logging with username and password.

by the way the error says host is unknown or can't be reached.

ray.wurlod wrote: So you try not to; manage the computation within DataStage using local variables and expressions, and you avoid the latency.

Ray can you please explain how this can be achieved through local variables and expressions.

Thanks in advance.

Your design should be like this Src--------->Tran1----------->Pivot------------->Tran2------------>Tgt_File In first transformer add one more column which will have @OUTROWNUM(this column would serve as a primary key to each row). Pivot stage will give you 5 rows for each row(@OUTROWNUM) In the seco...

Char(10) is the linefeed character, try it.

I did an experiment with User Defined SQL and it worked. (I tested it on SQL Server). My target table is like this create table Abc (a# int primary key,b# int,c# int) The Column names I used on the target link were a,b,c The User defined SQL I used INSERT INTO Northwind.dbo.Abc (a#,b#,c#) VALUES (?,...

The job you are talking about wont populate the Hashed File, It is just for the creation of Hashed File(although can be used for clearing also).

Reject Link should not have a constraint.
If it does have one then all the records would get processed.
If it does not then only the rejected links would get processed.

Thank you very much so the constraints are executed in the rejected row not on the entire record set. No read my last post. For example let source data is 1 2 3 4 and on one link the constraint is inlink.Col<>2 and on the other link it is inlink.Col<>1 and the Rejected Flag is set for it then First...

Morethan that if the Constraint is anyway satisfied by a non rejected row, then also the row is selected on this particular link.

The constraint on the Link which handles Reject Rows is executed once the rows are rejected,
i.e,

First Rejection Flag indicates that this link will process Rejected Links, after that the corresponding constraint gets applied on the Rejected row.

In such cases
We provide the column name in the derivation and use a different name for the datastage column name.

Like

Column Name | Derivation
PCLINE | PCLIN#E

The permissions to the datastage can only be given to the groups of users on your operating system, not to a specific user.

I think you are talking about a range lookup

Search the Forum with the term "range lookup".

Hope this is what you are looking for.

Looks like a key column into the Hashed file that should be not null is getting a NULL value.

Hi, DS_MNP_MNP.20060117_031852.JobControl (DSRunJob): Waiting for job DS_MNP _MNP_XFM.20060117_031852 to start 77 WARNING Tue Jan 17 03:20:12 2006 DS_MNP_MNP.20060117_031852.JobControl (@JOB_DS_MNP_MMP): Controller prob lem: Error calling DSRunJob(DS_MNP_MNP_XFM.20060117_031852), code=-14 (...) Reg...