DSXchange

Hi, we've just setup a new server with DS 8.0.1 . first tests seem succesfull. We've had some strange issues with jobs failing , which would run succesfully after a simple restart. We are not sure what the issue is but we were able to bring it back to a very simple testcase: One job with a rowgenera...

as far as I know there is no issue with connecting from a 9i client to an 8 database. However there is an issue from datastage 8 with connecting to Oracle 8. No matter which driver: it is not supported.

hi, we're working in a solaris environment, where datastage jobs are scheduled trough autosys. That means we have to create a short unix script for every workflow we schedule. At this point we've created a runds script which is a wrapper around somedsjob commands . (most of this is indeed info from ...

check your hosts file
I assume you have a windows client there it is under C:\WINNT\system32\drivers\etc .
Here you need to add the IP and name of your datastage server.

hi, did you get this working? We have exactly the same error, but not with the localhost. We did a new installation , got one client connected properly, but another client gave these errors. Difference here is that on the working PC a local administrator is using this, while on the other PC this is ...

Ray,

One of the requierments is to keep the paswords hidden. How can we make sure nobody is able to read them if they are in a file?

hi, We have 2 requierments which we need to combine - shield off all DB-paswords from everyone within datastage - create a Job to do an oracle materialized view refresh on all databases. What we were planning to do: - create structured environment variables (example for a database called cust we wil...

Chulett, We have a single oracle PROFILE script which is indeed used for all unix scripts. This script is offcource smarter then just setting the same environment for all scripts . At this point we solve this with a workaround: if we select from oracle using the 'table' option it fails. When changed...

Ray, I think your statement is incorrect. When you have an Oracle stage in a parallel job there is an option for 'partition table'. By using this you can read in parallel. How does it work: you give a tablename to this parameter. DS will look for the min and max rowid for this table and will add thi...

I don't have access to the premium content right now (request is in the internal pipeline...) so I can only see your first line. I know NLS_LANG is an oracle specific thing. However I need to follow standards which are applied to our full unix environment. One of these is that no Oracle settings are...

Hello, We've just setup Datastage 8 with NLS enabled. Previously we were working on 7.5 without NLS. So I have no NLS experience Our Oracle DB is set to american_america.al32utf8 , while the client connection is configured as NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252. (this is something that's working ...

I don't know your job so I'll make some assumptions. I suppose you have a second source where you have the 7 key colums+ the 4 columns to be updated. If you select all records from your table, all columns exept the 4 and you join this with the second source, you get the full new record. Insert this ...

On Oracle I would never update all records of a table. Even if you have 100 columns and only need to update 4 it will be faster to create a new table, load it with the full records(while loading change the 4 columns you need to update offcource.) Once this is done rename the old table(to _archive) o...

I suppose that you mean you get the error for all varchar( and char?) fields in the oracle table, not for all fields? I would say to divide allready in the oracle stage. Maybe just do a test: write a 50 character string in the DB, using all special characters(so a string that would need the 200byte ...

Indeed best to be consistent, but not on varchar(200) but on varchar(50).
varchar(50) will hold all your possible oracle strings.