DSXchange

Hi, Say my source data has 1M records. 10 records have flag = 1, the remainder have flag = 0. The two scenarios go down separate update links to the target table. Flag = 0 is Update existing or insert new. Flag = 1 is Update existing only. Problem: Flag = 1 implies that there is an existing record i...

3b) No, there's no "overwrite" capability. While you can choose a specific major number, it always controls the minor number and will give you the next available minor for that major. Now, I guess you can "cheat" and use the Manager to import an newer edition of a particular ver...

Hi, Some questions on named batches in version control : 1) I created a named batch when I initialized from DEV --> VERSION. I've decided I don't like the name of the named batch. How do I rename it? The batch properties window has the name greyed out/protected. Why? 2) I'd like to use this named ba...

This is a long shot, but... Before I reinvent the wheel (ok, maybe this request isn't as common as a wheel!), has anyone developed any Beyond Compare user-configurable rules to ignore unimportant differences between DSX files? Examples might be: * VC LOGS * ^1_1 05/26/09 14:03:57 Batch 15122_50672 I...

(For anyone familiar with the "Beyond Compare" utility...) What I'd love to see is "Beyond Compare for DS Projects": 1) Pick base file, pick comparison file, compare, give differences report 2) Pick base project, pick comparison project, compare, give differences report, which in...

This is resolved. Thank you to Craig for the ODBC vs. DRS stage "trick", and Jack for his comments on best practice architectural approaches.

You could try switching the DRS stage to ODBC or switching to the ODBC stage itself, it's the only one I'm aware of that will not care if the parameter markers (or lack thereof) do not match up to the columns in the stage. I personally know the ODBC stage supports this as I've taken advantage of th...

What database? And just as an FYI and AFAIK, the DRS stage always uses the ODBC style parameter markers which are unadorned positional question marks - no colons or numbers or anything else. Sorry...SQL Server 2005. Perhaps the issue will go away once I write the "real" SQL, which will be...

Hi, Scenario: We do a data load. We get word the source files provided were incorrect. We get new source files. We want to delete appropriate records from the target tables prior to the (re)load (i.e. any records in the target tables matching the effective date(s) in the new source files). Some deta...

Is there a better way, or is this best practice to, as the subject says, "clear logs files in one shot"? Use the auto-purge settings. Maybe with tighter rules than you currently have in place. That's what I'd regard as best practice. Thanks Ray. I'm currently just using this utility in ou...

(May as well just add to this thread rather than starting a new one) So I read this thread, and also http://www.dsxchange.com/viewtopic.php?t=82586, and http://www.dsxchange.com/viewtopic.php?t=106690 See also http://www.dsxchange.com/viewtopic.php?t=128396&highlight= Plagiarizing from http://ww...

I need to tweak the Universe SQL code to return more stuff, such as job type, but searching the forum should give me what I need. As an FYI in case someone finds this on a search: This is my final Universe SQL code: SELECT EVAL "FIELD('Server|Sequence|Mainframe|Parallel','|',JOBTYPE,1)" A...

Hi Craig and Kim, Craig's post led me to search on DSPrepare job, which led me to http://www.dsxchange.com/viewtopic.php?t=128186&highlight=dspreparejob. My current approach: ResetJob routine: $INCLUDE DSINCLUDE JOBCONTROL.H JobName = Trim(pJobName) JobHandle = DSAttachJob(JobName,DSJ.ERRFATAL) ...

Hi, Say I have Project --> Jobs --> 00_Sequences category. What I want is a job that will reset all jobs in that category. I can build this as a separate sequence job, but it's always out of sync as soon as new sequences are added. In pseudocode: * List all sequence jobs in 00_Sequences category * F...

No Ray, what I asked was: Is there a way to merge the rows in memory, without having to write to one or more intermediate seq files, hashed files, or db tables, then coding the merge "manually"? What you replied was: Link Collector stage, Transformer stage, Aggregator stage ("Last&quo...