DSXchange

Im new to datastage scott, but perhaps you could look at the conversion functions in datastage. ie Iconv and Oconv, along with the D code function (the help file explains the use for the conversion types). I think that with that you could remove the timestamp and compare the dates with a normal if s...

The only stage types I can find are: active, passive & external. We are running DataStage v4.1 with NT SQL Servers and Unix UDB v7.1. Is "derivation" an Oracle option only? If so, looks like we may be stuck with using aliases unless you have another suggestion. -----Original Message----- From: Ray W...

Hi How can you compare 2 dates in datastage. 2 source tables (ODBC oracle) - 1 field in each is a timestamp, want to compare 2 timestamp fields and only input matching records to target target (ODBC oracle). I think my problem is the time part of the timestamp field. can you format timestamp to igno...

The derivation text in the file stage (columns tab) should take the place of the column name in SQL statements. For example if you have an ODBC stage, and load columns from a table definition called CUSTOMER which has a column called NAME, then the derivation text will be CUSTOMER.NAME. If you are u...

This is a topic for an orphaned message.

Congratulations to the New England Patriots. I took the afternoon off work to watch the home team (having spent 4 years in Boston) beat the St Loius Rams - and it was well worth the time off work

Hi everyone can someone tell me where to find the &PH& directory I have a job which has this week just started giving an adnormal termination In most cases just recompiling and rerunning the job has been sufficent Yesterday this did not work so for the third attempt it was run under debug mode and w...

Which stage type are you using? Most stage types include a "derivation" for each column, which is allowed to be the fully qualified column name (for example table.column, or at the extreme, schema.owner.table.column), and these fully qualified table names are used in the generated SQL. -----Original...

Ross, The &PH& is a sub-directory of the project directory. It contains UNIX files of the Datastage processes for a job. You could use the UNIX more command on the appropriate file to see what the problem is. It could be that you have a broken file which needs to be fixed if you cannot repopulate it...

Each DS project directory has its own &PH& directory. Typically the project directories are created in: $uvhome/projects. For example, $uvhome/projects/TEST_PROJECT1. Be sure to get to the &PH& directory using "cd &PH&". When you get the directory you may find that each entry is another directory fo...

It is in the project directory. You can find that path in administrator. -----Original Message----- From: Ross.Ecclesfield@vodafone.co.nz [mailto:Ross.Ecclesfield@vodafone.co.nz] Sent: Saturday, 2 February 2002 10:05 AM To: datastage-users@oliver.com Subject: In the unix directory structure where is...

Margaret, You may just trick the SQL generation avoid the ambigous column error by 1. declaring aliases of the tables in the "Table names Clause" .. say Tab1 A, Tab2 B 2. qualify the column names with the proper alias .. say A.Col1, A.Col2 .. if the Col1, Col2 columns exist in both tables. (dont for...

The general answer would be to use table aliases, however... I dont really follow what you are trying to do - generating SQL in DataStage to use elsewhere? The other way round? Could you explain (in more detail) what you are trying to do and where you are getting the errors? -craig Margaret Perritt ...

Our Warehouse group is uses DataStage to generate SQL for table joins. This works fine as long as the column names are unique. If the same column name is used in more than 1 table, Datastage returns an error. What is the best way to overcome the issue of duplicate column names in table joins? Margar...

Scott, Hopefully youve gotten some joy from Ascential in the last couple of days. I finally had a chance to try this on our 5.1 install and did not have any problems with FTP using either the host name or ip address. We are running Compaq Tru64 Unix Datastage and ftping to other Unix platforms or ma...