Search found 71 matches
- Wed Mar 08, 2006 11:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC parameter for timeouts connecting to SQL Server
- Replies: 0
- Views: 1835
ODBC parameter for timeouts connecting to SQL Server
Hi, I have a number of server jobs running on our Unix server connecting to SQL Server databases with ODBC plug-in stages. We keep getting ODBC timeout errors on some days and not others.It's very intermittent. Errors look like the following : "DSD.BCIConnect connecting to txu_hds, call to SQLC...
- Wed Dec 21, 2005 8:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Conversion
- Replies: 3
- Views: 2808
- Wed Dec 21, 2005 7:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Conversion
- Replies: 3
- Views: 2808
Re: Timestamp Conversion
Have you looked at ICONV and OCONV ? Else write your own routine.har wrote:Folks,
Input Filed datatype is varchar and records are in dynamic format..
Ex: 2/24/05 0:00:00(mm-dd-yyyy)
2/1/05 0:00:00
11/7/05 0:00:00
I'm trying to convert into date format : 2005-02-24
Any idea's..
Hary
- Wed Dec 21, 2005 7:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Updating Oracle table with a date lookup
- Replies: 4
- Views: 2801
Re: Updating Oracle table with a date lookup
Hi I am updating an ORACLE 8i table with where date = date Incoming date field is selected in the format TO_CHAR(DATEfield,'YYYY-MM-DD HH24:MI:SS') Then I am using ICONV/OCONV Combo to get this date format in a stage variable Oconv(Iconv(Left(Link1.DATEfield,10), "D-YMD"), "D-DMY[2,A...
- Wed Dec 21, 2005 6:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: outer join two tables in seperate databases
- Replies: 10
- Views: 4919
i read that transformer performs equii join. and even in the job it is performing equii join. is anything that i can specify to make it a left or right or full outer or inner depending on what the result should be? Nope the default is an outer join, you can make it an equi join by putting in contra...
- Tue Dec 20, 2005 5:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Sequence Restarbility
- Replies: 3
- Views: 2575
Re: Job Sequence Restarbility
My JobSequence got aborted after running job J2 and jobSequence status is in Finished Status , instead of Aborted status . **************** My Sequence Job does not actually say it aborted, it says its finished, though Job J2 failed(aborted). Though it didn't start J3 & J4 (which is correct) , ...
- Tue Dec 20, 2005 5:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction using dates
- Replies: 2
- Views: 2186
Re: Extraction using dates
Hi, My Job is quite simple with a very simple logic, but got strucked .. :!: I've developed an extraction job, where the extract depends on parameters BeginDate and EndDate.But , now I have to add a new parameter called PERIOD. If Period is= A ( Dates for the very recent Year that is BeginDate=01-2...
- Tue Dec 20, 2005 5:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01555 error
- Replies: 11
- Views: 7119
Re: ORA-01555 error
If this error occured while the select and update took place simultaneoulsy, then it makes sense to me. But the update job finished 3 hrs before this error Aborted the other job where i just read the data from the table Help me with this Thanks Kishan[/code][/quote] Since you run your jobs in parall...
- Mon Dec 19, 2005 7:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Timeout
- Replies: 1
- Views: 2556
ODBC Timeout
Hi, My server jobs access SQL Server db from Unix. All jobs run fine but occassionally we get an error : P462LoadVersionstg00..Audit_Version: DSD.BCIConnect connecting to txu_awdb, call to SQLConnect failed. SQLSTATE=HYT00, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver...
- Thu Nov 24, 2005 5:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read value in from SQL Server in Routine
- Replies: 4
- Views: 2947
- Wed Nov 23, 2005 11:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read value in from SQL Server in Routine
- Replies: 4
- Views: 2947
Read value in from SQL Server in Routine
Hi, From my job sequence, I need to run a Routine first which will query a SQL server table and then pass the value from this routine into the job that will be run as one of the job parameters. If it's Oracle I would be calling SQLPLUS from the Routine and using the ExecSH in Unix, but now that this...
- Tue Nov 22, 2005 11:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal termination of DataStage - OCI8 stage
- Replies: 5
- Views: 3269
Re: Abnormal termination of DataStage - OCI8 stage
Has anybody come across similar problem? Several of our production DataStage jobs abort when extracting data from Oracle tables. There is no meaningful error message. The abort happens once the extracts reaches a certain number of rows (about 15.7 million). It does not matter if the extract is to a...
- Tue Nov 22, 2005 4:21 pm
- Forum: Data Integration
- Topic: Consultant adamant in not using SDLC for data warehouse dev
- Replies: 7
- Views: 24569
Hi, Thanks for all your inputs. I didn't know of the spiral lifecycle. Guess I do now. At the rate he's going I just think he's ripping the company off ,thankfully I'm not the one paying his wages. From reading about the spiral method, there has to be some sort of controls but in our case, he's doin...
- Tue Nov 22, 2005 4:21 pm
- Forum: Data Integration
- Topic: Consultant adamant in not using SDLC for data warehouse dev
- Replies: 7
- Views: 24569
Hi, Thanks for all your inputs. I didn't know of the spiral lifecycle. Guess I do now. At the rate he's going I just think he's ripping the company off ,thankfully I'm not the one paying his wages. From reading about the spiral method, there has to be some sort of controls but in our case, he's doin...
- Mon Nov 21, 2005 11:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Deleting corrupted Empty category/folder
- Replies: 8
- Views: 4731
Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know. :wink: As of version 8.x there is no more Manager client. Its functionality is all moved into the DataStage/QualityStage Designer. Fewer client tools, yay! I thot it would be more logic...