DSXchange

It's on plan to take it on the road, but there are some rather intransigent logistical worries, like what to do for a server (connect to Texas is one possibility), continued access after the class for a while, finding more instructors, and so on. Even different paper sizes; so far notes have been pr...

Or Downcase().

Welcome aboard. :D Naveen's post informs you that you posted a question about parallel jobs in a server jobs forum. You can perform the INITCAP function in Oracle itself, as part of your column selection clause in your SQL passed from DataStage. There's no direct equivalent in parallel jobs but, in ...

what happens when size of a Hash file increases? It gets larger. If there's free space within its structure that's consumed. After that, it either grows by adding pages (dynamic hashed file) or by extending groups into overflow. If it's a 32-bit hashed file, the write that tries to take it beyond 2...

If you're on 7.5x2 you can use StartLoop and EndLoop activities in your job sequence.

Provide a DEFFUN declaration that refers to the function itself. DEFFUN MyRoutine(Arg1, Arg2) Calling DSU.MyRoutine Then, within your routine, you can invoke it recursively. Make sure to give yourself an exit strategy. Example FUNCTION Factorial(X) DEFFUN Factorial(Arg1) Call...

Dynamic RDBMS Stage. Introduced (iirc) in 7.0.

I already have a job that checks using a routine the maxdatetime value, but it throws 'literal not in the format' error. I tried like this : say DtTime = '10-03-2006 08:15:25' Dt = Left(Time, 10) Tm = Right(DtTime, 12) D1 = OCONV(ICONV(Dt, "D/DMY"), "D/MDY[2,2,4]") T1 = OCONV(ICONV(Tm, "MTS"), "MTH...

You'll find that easier if you do the export including defaulted properties. Then you'll find that more things are replaceable, and you don't have to worry quite so much about inserting new structures.

AsInteger may generate warnings, because the potential exists for your decimal number to be too large to fit in an integer. If you can be 100% certain that this will never be the case, equip a message handler for this message in this job to demote the warning to informational.

Looks like it.

Make sure there are no spaces in the pathname.

Please post IBM's exact reply. We understand that English is not your strongest language, but leaving out one layer of interpretation (yours) may help us to help you.

I don't think I'll ever get used to Texas portion sizes! Thanks for the kind words. There's a lot of work goes into preparing and setting these up, particularly from the Strategies2Learn team and from Walter, otherwise this site's web master, who worked amazingly long hours to ensure this class's su...

You've got whatever the database provides, and anything you design into DataStage. Research.