DSXchange

SQL Query

So the date function is it to just check if the passed value is date format and not to use within oracle plugin?

I found few topics similar to this, but this one is somewhat different. I have a sequence_TOP calling another sequence_LOW calling an extract job . I send a value '2007-01-01' through sequence_TOP to sequence_LOW and which in turn passes it to the extract job. The parameter type is declared as 'DATE...

It doesn't work for me even if I put the literal (space). I get the following error always. seq_ext_ref_blng..JobControl (DSSendMail): Parameter 4 ('[ParamValue/Limitvalue is not appropriate]') does not start with a keyword seq_ext_ref_blng..JobControl (@Failure_Notify): Routine DSSendMail did not f...

I need to execute a bunch of SQL Statements. (There are some truncate statements and some delete statments) target is Oracle db. what is the best way to execute the bunch of sql statements? what i tried is: DummySeq_File-->X-->DRS_Stage one column i mentioned as a dummy value and update action:User ...

I don't know how anyone can make a blanket statement about 200MBs being a limit for DataStage, there's way too many variables involved. a) Can you give me an idea about those variables involved.. All I know is size of the file .... which probably depends on physical memory available. b) Could there...

your job falls over dead. Nothing more than that, bang abby-normal termination dead. a) When such kind of error occurs, is there a way to deal with it. b) If complete XML file (data) can't be accomodated in physical memory, then doesn't it access with hard disk through mechanism of paging. The time...

NONE of the key columns in a hashed file can be null. If the reference key expression is null, the lookup is not attempted. You can prove this using the Debugger. Hi Ray, Can we trim the Key field before writing to hashed file. And while doing the lookup, can we do lookup with empty string like ''?

I had this in a trasfrom function NullChecking,

Shouldn't an if else construct be in transform function,
I have now changed the code to

In all cases, the 'issues' are the same - your job falls over dead. Nothing more than that, bang abby-normal termination dead.

Why does this happen in case of XML stage and not sequential stage, as I use about 400GB size of txt files with sequential stage.

I was looking for recommendations on using XML files. From, http://www.dsxchange.com/viewtopic.php?t=109773 It appears that, Recommended ways : a) below 50MB, 'two field' way works fine (offcourse depends on memory). b) below 500MB, second methodology, without folder stage. c) Above 500MB, if other ...

chulett : What kind of sizes would you be dealing with? There are definite size limits when using the traditional 'two fields, all content at once' methodolgy with the Folder stage. Cutting that back to just one field to pass the filename and letting the XML Input file read the file directly pretty...

Not exactly sure of the nature of your question...are you comparing the Seq Stage vs the XML Stage for reading XML documents? or the merits of using XML at all? That's a huge issue and one that is far bigger than DataStage..... Ernie I wanted to know about limitations while using XML, when compared...

I haven't used XML stage until now..

Are there any pros/cons of using XML stage verses sequential file.
Like
a) XML stage have size constraint???? where as sequential file doesnt.

I meant to say, is there something which I am not aware of, Like arg1 & arg2 are both Decimal datatype (in sequential file), anything of that sort causing this problem. (changed them to numeric, bigint, still same result) ====================================== I am getting crazy, feels like ther...