DSXchange

Hi,

Check the entry in hosts file in etc folder of Windows.

C:\WINDOWS\system32\drivers\etc

There should be an entry for 127.0.0.1

All the best.

--Rich

Hi, I have experienced the same problem on Windows 2000 and what I did was to create a user named DSADM and give him administrator priveleges. I think I set Password change on next logon. Rebooted the pc changed the password. I clicked on Datastage client tools set the host to be localhost or 127.0....

Hi, Iam writing my database rejects to a .csv file. I have a field EFFECTIVE_OUT_DTS which is a timestamp and is a null field. I got this warning initially At field "EFFECTIVE_OUT_DTS": Exporting nullable field without null handling properties I used the techique you had mentioned in your ...

Hi, 1. What do u mean by "null_field" value. There is no property like "null_field" in the sequential file stage. Do u mean the value of Column A in the sequential file should be 10 spaces. Pls explain 2. If a field contains a value of 10 spaces does Datastage convert it to NULL?...

Hi Ray, What do u mean by you can specify a date picture of 'YYYY-MM-DD HH24:MI:SS' for example, and it's all OK. You mean I can change the datatype in Datastage back to DATE and insert a value in the form of 'YYYY-MM-DD HH24:MI:SS' or let the datatye be timestamp and insert a value in the form of '...

Hi,

Iam using oracle database(Oracle 9i) and when I import a table definition from Oracle the datype of the DATE field is converted to Timestamp automatically.

Can anyone explain why?

Thanks
Rich

--Pride comes before a fall

Hi, I created a simple PX job where I retrieve data from Oracle. I imported the table definition and I provided all the connection parameters and when I clicked on the view data button I get the following error Access to sys.dba_extents required but not available. I created the same job as a Server ...

Ray you have mentioned that hash file is memory based but as far as I know it is file based(two files .OVR and .DAT are created) and the data is loaded into memory only if the pre-load to memory option is selected. There is a stage in PX the lookup fileset(this creates a file with .fs extension) I t...

Ray, I tried and Iam able to import table definition for Oracle.

Thanks

--Rich

Ray thanks for your comments. In my server jobs I used to populate the hash file and then use hash file for lookup for loading data. From your comments what I understand is that I should populate a lookup dataset and use the lookup dataset (The lookup dataset is resident in memory and not in file) f...

I have been using hash files for lookups all this time. Is lookup stage an alternative to hash file stage. Can anyone explain the significance of lookup stage and difference between hash file stage and lookup stage. Cant we use hash file stage in parallel jobs? If so what is the appropriate stage th...

Is there anyway that we can import table definitions of any database without creating the ODBC. Instead of using ODBC table definition in Datastage Manager is there anyother way we can import the table definitions of any database(Teradata, Oracle)