DSXchange

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...

kumar_s wrote:Hi,

ICONV and OCONV for parallel edition...


Better try useing StringToTimestamp(%string%,"%mm/%dd/%yy %hh:%nn:%ss"%])

-Kumar

My apologies, didn't see that it's for parallel.

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

Have you looked at ICONV and OCONV ? Else write your own routine.

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...

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...

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) , ...

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...

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...

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...

loveojha2 wrote:The tool would be isql.exe or osql.exe

Hi,
Are isql.exe or osql.exe available for Unix ? I am running DS7.5.1 on Solaris 8.

Nick

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...

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...

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...

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...

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...