DSXchange

Sorry...I am looking for a parallel answer. I accidentally left the default of "Server".
Thanks - - John

Hi,
Can someone move this to the enterprise forum. We are running 8.0.1 enterprise edition at our shop.
Thanks - - John

Hi, I have an input table with 2 columns: ITEM_ID and TXN_TYPE with values for example as follows: ITEM_ID TXN_TYPE 1 A 1 B 2 A 3 A 3 B 3 C I want to convert this so that there is one row per ITEM_ID, with columns for each occurrence from the original table. For example: ITEM_ID TXN_TYPE1 TXN_TYPE2 ...

Thanks! Now for the question:
Why when changing the target from the MS SQL Server Load to an ODBC stage with every thing else unchanged he runs clean. Why would the arithmetic overflow just show for the bulk loader?

Hi, A developer just ran into a problem when he is running his data into a target MS SQL Server Load stage...he gets the warning: cfsstg_finance_database_stage_2_jptest..Cfsstg_finance_database_stage_2_ins.IDENT2: Arithmetic overflow When he changes the target from the MS SQL Server Load to an ODBC ...

Thank you all for your input. I have been usng the control panel to start and stop the DataStage services but unfortunately it does not allow me to do one at a time.....it's an all or none deal.

Hi,
Would anyone know the windows equivalent to running:
DSEngine/bin/uv -admin -start

Thanks - - John

Hi, For the past few weeks we have been having many of our parallel jobs just hanging on the OSH script (...) step in Director. There is no affect o the server jobs all run normally, but our parallel jobs randomly get hung up. Sometime s it is when we kick off a simple job minutes after midnight tha...

That's what I found to be odd...there is no "OFF" in the User defined SQl. I have created my own version of the job to verify.

My profile is showing as Server but this is a parallel job.

Hi, We have a developer who exceutes the following fine as an SQl statement in query tools. ############################################### BEGIN SET NOCOUNT ON; DECLARE @EventIDRecordType VARCHAR(26); DECLARE @Name VARCHAR(256); DECLARE @Members VARCHAR(3000); DECLARE @Current_EventIDRecordType VAR...

After looking at their job a bit more, It looks like it may be an issue with SQL server 2008 "Date" type. When we import the medadata the column definition comes in as NVarChar. Since we do not have NLS installed we cannot use this and anything else we try gives a conversion error writing ...

Some more info....when I bring the date in as a time stamp and then try inserting I receive teh following warning: Is their a function I can use in the transformer to give me the 2011-05-05 of the eff_dt field currently 2011-05-05 00:00:00.000 Server:NJROS1BBLA0704 Project:CFF Job No:36 Job name:CFF...

Hi, The development team is bringing in a timestamp from SQL server 2008 as 2011-05-05 00:00:00.000 and they need to just grab the date portion as 2011-05-05. The result needs to be inserted into SQl server 2008 as a date field. I've tried changing their sql to bring the date in as a Character field...

Just wanted to add that replacing the origina sql with: select 'BX5216.PPRP.DSOUT.VAL035.' || REQUEST.F_GET_MF_FILE_EXT ( CHAR(DATE(Current date),ISO), '' ) ||'~' || 'BX5216.PPRP.DSOUT.VAL0001A.' || REQUEST.F_GET_MF_FILE_EXT ( CHAR(DATE(Current date),ISO), '' ) as mf_Date_Qual from sysibm.sysdummy1 ...