DSXchange

You just need to pass in the timestamp as a Job parameter and reference that in your file stage.

hi,

best to do the pre-processing outside of DS.write a unix script to do that. investigate using grep,sed and other unix functions. not hard to do...
once your file has been split up into proper XML chunks then your job can read it and parse your XML.

JS

You can also refer to the DS Installation Guide.

well for starters perhaps you should try not using the Express Edition of C++ Compiler?

Did you hash partitioned your data? Your lookup could have the entire file hashed so that would work.
just my 2 cents.

Hi , You need to make sure that you are getting the entire message (XML file) from MQ. So before you run it into the XML stage, just create a simple job like this : MQ --> Seq file If the Seq file is created as a good XML file then you're good to go e.g Seq File --> XML Input You need to debug where...

Hi Though I have not worked on Oracle E-billing but I had done work around Oracle Retek (retail merchandise system). One comment - make sure you understand what all the validation rules are. Most of the load programs have their own validation rules and most of these are built in PL/SQL which is proc...

Can you please clarify "humanly/computerly" ? Do you mean what could be input from the keyboard? Or that your data will contain all possible ASCII characters eg char(167) ? Producing XML is possible with the XML Output stage. Try the IBM Developerworks website , there are some handy tips/e...

In the XML Input Stage tab, under Transformation setting make sure you define the namespaces that you use in your XML file.
Then in the Output make sure that the Description field has prefix that matches what the namespace prefix is.

Have you successfully parse the XML before in other jobs?

JS

jdmiceli wrote:Odd as this may seem, I am almost in agreement with Dinesh and the consultant.
.

but Dinesh is not in agreement with the consultant

Here's the IBM web site on using Java for Real Time applications.

http://www.ibm.com/developerworks/java/library/j-rtj1/

I'd happy to be proven wrong but has anyone built any real-time systems for a bank using Datastage?

And if it is a banking type transactions again don't use Datastage. Can you please explain us why ? I didn't understand this point. the OP is after a real time transaction system like those used in the banks. DS is good for batch processing not real time transactions. Sorry for the confusion.

A different config file is only really useful is your jobs have been designed properly to make use of parallel processing. Best to start by looking at the job and see what you can do to improve things. Next you can just test your results with different config files ,say start with a 2 node config fi...

its an database, like ms acess, i like to know if we using parallel enviornment how the update will update in target database.and what the difference between server enviornment target database updation andtarget database updation. in real time take eg like bank they need to update an new column and...

Your XML file is created in your unix filesystem,so that's probably where you should start. To view XML in the vi editor is not easy so best way to do that is ftp the file to your PC and use one of the XML tools to view it.
Btw an XML file is no different to other files as it's just text.