DSXchange

Ray, thanks for the response. I ran verify.sql on the project with errors and got the following messages. ---------------------------- verify.sql schema project123 output: checking permission. * 'C:\Ascential\DataStage\Projects\project123' is not a DataStage account. * Data for the schema project123...

Ray, we replaced UV.Accounts file from previous file and all the projects are now visible in datastage client and admin except one project. I am getting error for this one project both in admin and while log in to designed. Below are the error messages. The directory you are connecting to either is ...

Hi all, we had issues with our datastage server and had to move to a new server with same configuration and similar environment. The datastage folder including projects folders were copied to the new server. When I login to datastage adim I am seeing only initial default project and no other project...

As far as I can recall, the Hashed Files stage automatically performs a conversion if the data type is Date. You can check for this by temporarily dropping your Oconv() function. The internal form ... Thank you Ray for the reply. 1. I did view data on hash file. I am seeing integer number (internal...

Any suggestions from gurus appreciated.

Hi, I have 10 million records loaded into a hash file and one of the fields is a date field. I forgot to convert it into timestamp (yyy-mm-dd hh24:mi:ss) format and the date loaded into hash file is in internal format. Now when I apply the OConv funtion to getthe date I am not getting the right date...

Hi,

I need to findout number of months between two dates same as Oracle function months_between. I can not use Oracle function because I am reading the dates from sequential file and loading into a table where I need to findout number of months between dates.

Any help is appreciated.

Thanks,
Sri

Hello, I need your help on Oracle enterprise stage. I am reading two fields (cal_year and cal_quarter) from an Oracle table using Oracle enterprise stage and writting to a sequential file. When I run the job following warning messages are logged. Fields in database: cal_Year - Number(4) Nullable cal...

Hello, the error is resolved. I found a solution while googling. Here is what I did if it helps anyone in future: Apart from what I mentioned earlier in this post, 1. I have changed the extention of "C:\IBM\InformationServer\Server\DSComponents\install\install.liborchoracle" to "insta...

Hello, I am running into errors while trying to view data using Oracle enterprise stage. I have referred documentation and searched this forum but still unable to resolve the issue. Your help is really appreciated. Error details: ------------------------------------------------- ##E IIS-DSEE-TOSH-00...

[/quote]

I missed to mention that I also tried this command and it returned saying this command do not avaible in this environment. I guess "SH" is for UNIX environment.

Please note I am able to view the data by manually entering the parameters instead of defaulting to enviroment variable values. Also, I have added and verified that a database entry exists in tnsnames.ora file.

Hi, I am trying to view data from Oracle OCI8i stage and receiving "ORA-12154 TNS:Could not resolve service name" error. Details: server job reading from a sequential file and writting to a Oracle OCI8i stage. I am using environment variables for Oracle user id, password and connect string...

Total length of field names of all the 53 target fields is 1491 and max length of field name used for one of the fields is 47.

Any inputs appreciated.

No.