DSXchange

Again, how would you want to identify them? By name? By last run date? By status? By design? By category? Then, what do you want to do to them?

How would you identify the "unwanted" objects and what do you want to do with them?

Methinks some scripting would come it handy. Perl, ksh, bsh, whatever your preference.

Multi-row is available on the UV/ODBC, not Hashed file stage. The UV/ODBC stage has a SQL interface to the hashed file, but you incur penalties using it. The hashed file wil have to have secondary indexes added to the columns in your WHERE clause to avoid full table (really file) scans for every sin...

The only way you'll be able to get that to work is via the Stored Procedure stage as it needs to be executed in an anonymous block. The 'normal' call syntax won't work. Oops, I did not know that. I avoid before/after SQL tabs like the plague, prefering stand-alone jobs to execute them so that I can...

Use CALL in front of the procedure name: CALL dbms_stats.gather_table_stats('PSCOMMON','PS_LEDGER',NULL,NULL,FALSE,'FOR ALL COLUMNS SIZE REPEAT',1,'DEFAULT',TRUE,NULL,NULL,NULL); I've never tried using NULL to pass as an argument value, I think you need two single quotes instead, but I may b...

There are no declarations required. There are no data types. Variables automatically cast when necessary. Dates are text strings. Dynamic arrays (notated with < and > instead of parenthesis) need declaration to "" as in myarray = "" Read your DS BASIC manual on the Start button and learn a...

Control-M uses an agent on each server to start processes. You will need to use command line dsjob to start a job from the scheduler. I don't recommend that each job be a separately scheduled process, rather schedule a controlling Batch or Sequence job and let that manage the load effort. So, you'll...

Look at the dsenv file verify all paths are correct, especially the SHLIB LIB paths.

Well paste it here for us all to share!!

What was your syntax in the after-SQL tab? Can you please paste the statement. You need to use CALL spname; syntax.

As for your original problem, did you import the sp metadata?

Yes you are. DS doesn't have a date+time manipulation facility, so writing your own function is great. Checkout this for a headstart:
http://www.dsxchange.com/viewtopic.php?t=85788

sb_akarmarkar wrote:Create dummy column in both file with value "0" and join them on dummy column in merge stage with Pure inner join.

Thanks,
--Anupam

I'll have to try that out.

Hey, it's posted here:

http://www.dsxchange.com/viewtopic.php?t=85788

I've been scratching my head for about 3 days trying to figure out a way to do a cartesian product for a particular customer job without using a database, UV/ODBC, or customized code. I don't think there's any facility to do a cartesian product in the Merge stage. I've had to take the simplest solut...