DSXchange

Hi, I've managed to get some information into the Summary part of the Analytical information tab (through Repository, Metadata Sharing, Create Table Definition from share Table...), but it is very limited as stated by vmcburney above. However, the notes which I've made in Information Analyzer on spe...

Hi Guys, Thanks for the feedback! I rewrote the routine and added a extra function to validate input data: The "dateHyphen" routine now looks like this and it works, no matter what source data you pass it: ------------------------------------------------------------------------------ char ...

Hi Guys, I am building a job that requires the use of a C++ routine (client request). The C++ code is very simple, but it aborts with: 1)"Transformer_5,0: /bin/echo: write error: Broken pipe" 2)"Transformer_5,0: Operator terminated abnormally: received signal SIGSEGV" It runs fin...

Ok, I am out of ideas...

A call has been logged with IBM and I am awaiting feedback.
I'll let you know what the outcome was.

No, they dont...

Hi Guys, My client runs Linux Red Hat 4 Enterprise. Some jobs compile extremely slow. I searched the forum for the problem and found people complaining about 5 and 30 minute compiles. Some of my jobs take 6 hours to compile. They aren't even complex jobs. Source Dataset, Look-up, Transformer and a t...

I need to know how to backup datastage environment including DB2 files ,configuration files,settings for the project.

I've got a similar problem; can't get the odbc entry which was added in the odbc.ini to be listed in the Analysis ODBC DSN in IA (Analysis Database setup). My IADB lives in Oracle. And I've just tested a previously added Oracle ODBC connection through a Datastage job - got a Connection was successfu...

"LongNvarchar"

Hi Guys, i am facing very strange thing in version 8.1, when i import metadata using ODBC connection from SQL server 2008 i am unable to view data on a single field which is define as "LongNvarchar". i tried to change this field to other datatype but its complaining about "Datatype no...

I do Apologise to all suddenly due to a "change" by db server managment it suddenly works. I did see that call works and not exec/execute.


thanks
Mark

hi, I wonder if anyone can assist me, I have checked all over web and this forum, but could not find any pointers. My problem is such that my customer is migrating to Oracle 10g and they have implemented 10G vpd with context based authentication on all tables. to bypass this I need to run a procedur...

Hi Get the following error in DataStage when when enabling operational metadata for a job Cannot open OMD.XML.DIR I am trying to get operational metadata working in metadata workbench but the XML files are not generated in the following directory so I can't import it... :cry: C:\IBM\InformationServe...

Success !

So much brainpower - so little time !

Thanks a mil.

Barbara

Thanks for your help. I added this statement to my SELECT statement and the output was then changed to 0000-00-00 00:00:00, I then used a Transformer to check for that date value and changed it to the correct date format. As for the other problem I had with the carriage return statement. Something s...