DSXchange

Thank you all for your responses. Alas, I can assure its not missing the SQL statement. That was the first thing I checked twenty something times. The query is selecting from the dba_segments view in sys schema. The query in question is select sum(bytes) from dba_segments where owner = 'DATAMGR' gro...

the ODBC stage is the initial stage, it performs the extract and outputs to a transformer stage. there is no update action. There are actually 11 links from the ODBC stage to the transformer. They are all user generated queries and all generate correct results when I select 'view data'

Its a compilation error.

I'm getting an erro that states one particular odbc output lacks a SQL statement, when it does actually have a sql statement. Any ideas?

I'm trying to use the stored procedure stage to kick off....a stored procedure. It's aborting returning the following error message: LOAD_ACC_HIST_CHMX_STP..CREATE_EXTERNAL_TABLE: ORA-01036: illegal variable name/number I can kick off the exact statement in SQL*Plus and it runs without errors. The s...

We have two jobs that have been failing with two errors lately. Nothing has changed in the jobs themselves and other jobs using the same ODBC are running perfectly. They are simple extract jobs. ODBC stage -> transformer -> ftp or file. They are failing during the initial ODBC extract. Here are the ...

Yes, we physically moved our server from Florida to Pennsylvania. I apologize for being unspecific. I appreciate your response chulett, especially on a Sunday. The issue we were having was the user account for the scheduler was still under the domain from Florida. We switched it over to our PA domai...

We moved our datastage server and everything is working fine except for the scheduler not kicking jobs off.

Are there any windows services that need to be running? All the datastage services I saw were running. I've never run into this issue. Any ideas? Thanks in advance.

We've had a number of shell scripts in places for a few years, but lately they've been giving us lots of heartache. They are controlled by other shell scripts that we have, task runners. The task runners kick off the individual shell scripts, which in turn kick of a pl/sql stored procedure, then cre...

I have a job that reads from a text file and emails its contents to users. I've created jobs like this before that read numerical values and will send those values out to the users. If that value is 0 the job will loop until the value is not 0. My question is this, can you set it up to loop if the i...

excellent. That worked. Thank you so much!

select batch_strt_tmstp, batch_end_tmstp from DATAMGR.BATCH_LOG where process_id = 'T1_LOAD_XT_P2P_HIST' and trunc(batch_strt_tmstp) = '11-MAY-2007' this is the actual query I'm using. the 11-MAY-2007 will be rplace with a variable. It is a timestamp. I'm trunc-ing it because I want to collect data...

P2P_Hist_Count..ODBC_0.DSLink3: DSD.BCIOpenR results of SQLColAttributes(batch_strt_tmstp) gave MetaData mismatch COLUMN.TYPE Expected = Timestamp Actual = Decimal P2P_Hist_Count..ODBC_0.DSLink3: DSD.BCIOpenR results of SQLColAttributes(batch_strt_tmstp) gave MetaData mismatch MetaData mismatch on ...

Thanks for your help! It got me started on some interesting research! Here's the skinny. we have to system DSN data sources for the same source. The first is Ascential's DB2 Wire Protocol, the other is iSeries Access ODBC Driver. When I use the iSeries Driver, I get those messages, when I use Ascent...

Extract_Authorization_Log_Physical_File..Transformer_2.DSLink3: DSD.BCIGetNext call to SQLFetch returned informational message. SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client]Data has been truncated I've searched the exchange for this and have read the responses. It appears this is on the sourc...