DSXchange

Thanx Criag,

I was developing almost on the same lines.

Quick Q! How do I get the DSLInkInfo for a link in the job.. and make sure of that in the Sequence ?

Hi ! I have a load job that should be triggered when a row appears on the control Table. I am trying to write a control job which will call the load job. I am stuck at this place and I donot know how to go about this. The control job should monitor the control table (for the presence of row) every 1...

Hi !

I put a "/" as suggested by you, by still it doesnt work.

I was talking to some other guys here and they were telling me that this was because SAS was not installed on the datastage server. Is this the case ? Should we have SAS and datastage to be on the same physical box ?

Hi ! I am new to SAS connectivity with datastage. I have developed a small job (New Parallel Job using Datastage Server Edition 7.5.1A) to create a SAS dataset and am encountering this error. Please help me with this -Nagesh =================================== SAS_13,0: Program '/usr/sas/SAS_9.1/sas...

We got a similar error before and we checked the , in the Source file stage, "supress row truncation warnings" (in the format tab) and Make the "Incomplete column" (in the columns tab) (for each element of the row, except the last one) as "Retain" Hope this helps Nagesh

Hi ! We are trying to connect to SAS 9.1.3. We were told that to connect to SAS, the datastage server and the SAS server have to be in the same machine. I am not totally sure that this is true. We have an existing datastage server which, ideally, we would like to make use to create jobs. But install...

Hi ! We are trying to connect to SAS 9.1.3. We were told that to connect to SAS, the datastage server and the SAS server have to be in the same machine. I am not totally sure that this is true. We have an existing datastage server which, ideally, we would like to make use to create jobs. But install...

Hi ! The problem is with defining the constraint Lookup (Singlerecord) | lnk2 | v Src(multiRecordTable) ----------> Transformer ---------------> Target lnk1 lnk3 What do I mention in the "KeyExpression" part of the lookup.

Hi ! I am having a problem with the Lookups. Source File has 1 record (recordid) Lookup Table (RecordId, RecordName, RecordDetails) Target (File) I need to read the source file, lookup for values in the LookupTable where LookupTable.RecordId <= SourceFile.RecordID and populate the resultant rows in ...

try altering the table by giving "nologging" option

Alter table Emp NoLogging;
(where emp is the name of the table)

This will definetly speed up the processing and will also avoid writing to the Oracle Logs.


HTH
Nagesh

is that a work around for all expired licences

Hi !

Sorry to hijack the thread.. But its a related query..

I think changes to the dsenv file will apply to all the projects.
Our datastage server hosts a number of projects, and I would like to apply these settings only to specific project.

Can this be done ?

Regards
Nagesh

SrcLink TargetLink Source ---------------------> Transformation ---------------------->Target | | ErrorLink V Error Table in the constraint on the ErrorLink you can either use TargetLink.Rejected or (SrcLink.Rangevalue < Minrange or SrcLink.RangeValue > MaxRange) or TargetLink.Dbmscode <> "&qu...

I guess it has something to do with "fully qualified table name". The SQL query generated using SQL Builder might be Select <columns> From <schemaname>.<tablename> where <condition> and the table in that schema might not be having any data. I know that I am just speculating the cause of th...

Its very useful for me too...

Thanx
Nagesh