DSXchange

Ended up being a subtle typo while entering params in QA.
Thank you to everyone for offering their help.
~ ~John

Hi, I have just migrated a project from our dev server to the QA server. In administrator I updated the parameters for the DSN name/pwd/uid for the UDB server. When all the jobs were created the parameters had a default value of $PROJDEF. When I go and do a get sql info on any of the ODBC stages in ...

Hi folks, One of the developers here is loading a UDB column defined as decimal(7,2) and the delimited file he is using as input has the numeric fields that are positive preceded with a "+" sign for that column. Would datstage throw out the following error for the "+" sign or is ...

OK...I updated the source ODBC definition to decimal(31,2) and left the target @ decimal(15,2) and it ran without warnings. I didn't think it would work with the target being smaller than the source field.

I also wanted to add that I am summing the field via user defined sql...in the source ODBC stage. That is where the error is being generated

It comes up as a Decimal SQL type and both source and target are UDB

Good Afternoon folks, I have a few jobs that are summing up an amount field from a source table where the field is defined as decimal(15,2) and inserting into a summary table where the field is also defined as decimal(15,2). whenever I executye these jobs I get teh warning MetaData mismatch COLUMN.P...

Thanks Craig!!!!

That was it...I was missing the STage name.

SUre...within the nested condition in the triggers tab I have each of the link names under the name column "Custom-(Conditional)" for Expression type and one of these for the expresion column PERIOD = 'P11 ' Or PERIOD = 'P12 ' Or PERIOD = 'P10 ' For DSLink11 PERIOD = 'P07 ' OR PERIOD = 'P0...

Thanks Craig, I should have been a bit more clear ast to how I was processing. I am using the User Variable stage with the UtilitHashLookup function which assigns a variable wich is used downstream in the nested condition. The spaces were added because I have tried the expressions without spaces and...

I've created a Hash file for needed parameters. I have one value defined as UtilityHashLookup('hshDateTime','1',2) which gives me the current month of the data. I wanted use this value in a nested condition stage saying which path I wanted based on the Month. My expression was UtilityHashLookup('hsh...

Thank You! I thought the check box for Job executables was checked but it wasn't.
My mistake!!!

Hi, I am currently moving all the jobs in a DataSTage project from the dev to QA box. I am packaging using the Export ==> DataStage Component in the Manager. I select the whole project which selects all the radio buttons. When I import into the QA environment everthing comes across except I need to ...

Hi, DataStage is a newcomer to our shop and we will be implementing our first production job in Jan 2007. The data architecture mangement team would like to create a strategy to roll out the tool for use by every application area(all accessing the same servers). My initial impression and recomendati...

I also tried using the Stored Procedure Stage but I get the following: LOAD_GPFRI_DATA..Stored_Procedure_27: [IBM][CLI Driver] SQL1001N "PRIAC_DEV" is not a valid database name. SQLSTATE=2E000 Seems like it is not recognizing the Data Source. I have used this data source in other ODBC stag...