DSXchange

Hi, I inherited this query from a job in another project: SELECT 'job' as ObjectType, DS_JOBS.NAME as ObjectName, DS_JOBS.CATEGORY as ObjectCategory from DS_JOBS order by 1,2 I'd like to change this query, but need to know the schema for this table. I've downloaded every document (ok, not the platfo...

Say I have a sequential file like (example only): proc sql; select var1, var2, var3 from some_table ; quit; I'd like to read this as a stream, where the record delimiter is ";". So, the records would be: proc sql select\n var1,\n var2,\n var3\n from\n some_table quit In another ETL tool I'...

I already have such a routine, called FinalDelimitedSubstring. You get it as a bonus when you download my date routines Thanks Ray. I appreciate you sharing these useful routines. I think my particular routine is a bit more generic, but I may be recreating functionality already in the product. I th...

I was searching for methods to deal with Pathname / Basename processing, which lead me to this thread. kcbland's post (second one) gave me the idea to write a generic routine to process strings "backwards" (right to left). From this you can derive Pathname and Basename. Ray's post describe...

The workaround is to write a "wrapper script" that returns a hard coded zero return code, then call your dssearch (or any other command) from that script.

I'm using dssearch, not dsjob. dssearch is returning the number of jobs in the project as the return code. Which is not a return code.

I'll drop this one now. Hopefully IBM will change this behaviour in a future release.

"Not nice" is not a business case. IBM's response would be that the product works as documented. Hi Ray, We'll have to agree to disagree on this one. In just about all other Unix commands I know of (others feel free to chime in), 0 = success, non-zero = error. And then IBM's own product i...

Summary : Is it possible to suppress return code checking in a seq stage filter and before/after stage? Details : I want to write a job that creates a CSV file of all and/or subset of the jobs in a project (I'll filter the output in the job via constraints) My first attempt was a seq file with a fi...

I'm experiencing deadlocks again. Different scenario, but thought I'd just add to this thread... Flow of data in my job: Input data --> SCD2 processing --> Generate SKs --> Map Parent SK --> Final load ODBC1 ODBC2 The two ODBC stages both use user-generated SQL. The first (ODBC1) is doing Change Dat...

Interesting. A couple of points... Does it work if you add a semi-colon (or whatever SQL Server uses) statement terminator after each piece of dml? I've never had a select '*' work out well and you're just asking for trouble selecting something that technically can change into a fixed number of col...

Caveat: I'm inexperienced with the Version Control (VC) application, so my questions may be "obtuse". Design goal: 1) All the job parameters in the DEV project have the literal strings. For example: TargetDatabase = FOO TargetDatabaseUser = BAR TargetDatabasePassword = BLAH (encrypted) 2) ...

Yeah I was going to suggest SAS since it supports first.key and last.key processing plus conditional output. If you don't have SAS licensed (although it sounds like you do) you could also do this in perl, loading a hash (associative array with character keys) and outputing the hash (accumulated reco...

Excerpt from my job: Input Link ---> DRS Stage ---> Ouput Link The Input link is generated code, Truncate table then insert rows, and loads the SQL Server table fine. The Output link is User-Defined SQL as follows (excerpt): /* ----- Derive ParentCentralCustomerSK ----- */ WITH DerivedParentCustomer...

Sorry, I can see my question wasn't clear... Does DS provide an automatic variable for the text of the tablename? For example, if the DRS tablename is schema.table, my after tab on the output link might be: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(' #DSTableName# ') AND type ...

Hi, (I skimmed the Dynamic Relational Stage Guide before posting...) If I have a DRS stage with table name schema.tablename, is that table name available as a stage variable? I want to use it in the before/after tab. Not a biggie, but it would be nice if DS could replace a parameter with the table n...