DSXchange

I think you have the column defined with Lengh and scale on the source side. Modify the target column's length and scale to be in sync with the source. It should work..

Please create a routine (ToInteger) using the following code.. I am using it to convert the strings such as "001234" to integer, and it works great.. If Num(Arg1) = 1 and IsNull(Arg1) = 0 Then d = Field(Arg1, ".", 2) If IsNull(d) = 1 Then Ans = Int(Arg1) End Else If d[1,1] >= 5 T...

We are in test mode. Eventually all of jobs will be scheduled. On your comment "sort of Job Control wrapper that computes the data and then assigns the resultant value to the parameter" can you please be more specific. Also, how is the parameter default value different in jobs and sequence...

I need to pass sysdate -1 as default value to one of the job parameters to all of our datastage jobs. I tried to use Oconv(@DATE, "D-YMD[4,2,2]") in the default value and it throws an error: "Must have a valid date(not including time)"..

Any help is appreciated!

Thanks

ririr wrote:Hello -

I wanted to modify the hash file stages in some of our jobs to use the account name instead of directory path. What information do I need in order to handle the above situation.

Any help is appreciated!!

Thanks

You are correct kim.. This is a followup to my previous post

Thanks

Hello -

I wanted to modify the hash file stages in some of our jobs to use the account name instead of directory path. What information do I need in order to handle the above situation.

Any help is appreciated!!

Thanks

Use the Exec_SH(Routine). Call a shell script that executes the database procedure. I can send information, if interested.

I have some 500 Jobs that are using Hash Files as lookups and also populating Hash Files. The project is supplied by our vendor. Is there a command that I can use from the DS Administrator to update the Directory path to all the hash stages in jobs. PS: All the hash files will be using the same path...

The source data is read out of Oracle DRS Stage. I have a situation where I need to hold the previous row key data value in the source link and compare it with the current row key data value in the source link, If they value in the previous and curent row matches then I need to write the row to a di...

Thanks John, It worked like a charm!

I am trying to find a pattern in the source column and return Null, if the pattern is found.

For Ex: Source Column Record 1 has : "TBADA'
Record 2 has : "ADTBAAD"
Finding Pattern: "TBA"
Result : @NULL

Any help is appreciated!

I know it is a mess, but i have a requirement for doing so. I have a database function that inserts a record in to the table and returns a value, if the parameter passed is not found in the in the table from wich the function is returning the value. I need to know if i can call a database function i...

Can I call a database function from the transformer stage. I have a situation where I am doing a lookup in an hashfile to get the code value(Sequence Number generated by the DB) of the data flowing from source. The requirement that I have is, if the code value is not found in the hashlookup then pop...

Vincent You mentioned that you were able handle the update action by switching it across to Generated SQL and modify the UPDATE statement to replaced CREATED with UPDATED: When I try to update the column (UPDATE_DATE) ORA-00957: duplicate column name It is throwing the above oracle error. Below is t...

When you say two seperate links, are those on the target side. The target table that is being inserted/updated has to laoded twice for the two stage types(DRS or OCI9) individually.

The database platform that I am on is ORACLE.

Thanks