DSXchange

Ok so as it turns out I was never connecting to the db at all, I made a few changes to the odbc instance and I can now connect to the db but I am still getting no where, I can't even select tables here is the message I get now: Error Retreiving Table List. Error maybe database or schema in this conn...

I handled it by converting the date into a julian day added or subtracted the 3 months (-90) then converting it back to the date format:

DateFromJulianDay((JulianDayFromDate(lnkStmOut.POL_SYS_KEY_DT) - 180))

I changed to the ip address and I get the exact same error and in fact it just errors out faster with the ip than the box name.

Does anyone have any other ideas on this, I can import the meta data if I use an analysis server that is installed on my local windows machine but I can not import it using the analysis server on my unix box. I now am getting the following error: Unable to connect to database using DSN/service 'AHQ2...

I have done this first by converting the date to a julian day and since you wanted to know 24 months ahead add 730 to the julian date and then convert if back to date. It is a crazy work around but it works for what you need

I have a fairly large cobol copybok with comp-3 fields. If I want to be able to run jobs from the file what is the easiest way to import it. I have the file in both asci and binary and the meta data is imported into datastage with both the levels and occurs defined. Do I need to us a complex flat fi...

Ray,

It turns out that you do in fact have to have an Analysis Server Installed in both places in order to properly export and create new target db's in profile stage. Once the Analysys Server was installed on my Windows Machine and configured in profile stage then jobs ran fine.

Thanks for everyone's help, but according to the documentation It looks like I not only need an analysis server on my unix box but I need a copy of it on my client machine as well. I currently have a ticket in with ascential support, and i will see what they say. Any other help would be greatly appr...

It turns out that the ip address that it is trying to use is my local machine where the PS client is installed. I'm not sure why for the generate DB it is trying to do this but for all other processes that require the use of hte Analysis server it is point to the one on the unix box where my analysi...

I am attempting to build a new db schema and specs after I have completed a full analysis of a source db. I get the following error: 8/23 12:26:09: INFO - +ERROR 100 5208 There is no Analysis Server running at IP address 165.245.228.74 The thing the really jumps out at me is the fact that the error ...

I ended up putting the data on the AIX box however I also set up a local ODBC text connection to be able to browse the source data. Prior to setting up this text odbc connection I was able to do everything but veiw the source data.

If my Message Switch and Analysis Server Reside on an AIX box can I set up the Profile Stage Tutorial so that the sample data resides on my profile stage client machine? Basically I want to be able to use a ODBC text connection I believe, to connect to the sample data on my local machine. Any Sugges...

Yes oracle is running on this computer and I am able to connect to the instatance through other sql tools.

I have successfully imported sql server meta data into ps, however when I try to do the import on an Oracle DB it times out with the following messages:

MetaDate Loader Done.
Problem Number 88: The server program was terminated unxepectedly.
Please Call Technical Support.

Any Suggestions??

I have done column analysis on a table and when i veiw the results I attempt to view sample data i get the following error. Failed to Populate sample data. Under Connection Manager for the given source I have set up the browse option for the source, and the only option I have is to use the Repositor...