DSXchange

hi..
how do I list out what DSjobs use routine_A ?

currently, I export ALL to dsx, and build dsjob to read the dsx & output csv containing: jobname & all derivations. From there I do a search..

There must be easier way..

Thanx.

if I can infer by your example, you want to concatenate lines that have same ID. Here's how i'd do it: 1. read all fields into 1 long varchar --> file1 2. using Field() read out ID, & write to hashedfile HF_id (ID, str1) 3. in another job, src=file1 ; lookup: HF_id ; out=HF_id (key=ID) in Tfm, ...

if I can infer by your example, you want to concatenate lines that have same ID. Here's how i'd do it: 1. read all fields into 1 long varchar --> file1 2. using Field() read out ID, & write to hashedfile HF_id (ID, str1) 3. in another job, src=file1 ; lookup: HF_id ; out=HF_id (key=ID) in Tfm, i...

When Viewing data from seq file stage, sometimes I need to find a piece of data.. the problem is, when the file is huge, "Find ..." dialog box became "Not Responding.." any clean way to cancel out from there? so far, i have to clean up into dsadmin & kill the processes thanks...

Looking at your examples, I'd approach it:
a. get numeric part from string
use Iconv MCN to get numeric part

b. get string part..
use Ereplace, with arguments to replace numeric part above with "".

For lookup field in the hashed file, Is there any performance difference whether data type Integer is faster than varchar ?

The field is ph# about str(30), and the lookup contains about 7.5million records.

thanks - HT

here's my suggested approach: 1) [input seq] --> [T1] --> [output seq] output: append T1: Field(instr, "," , n) n: job param = N-th occurence of word (ie: 1st=abc, 2nd=def) 2) call job (1) using another job with BASIC FOR 1..n LOOP in your example, calling job1(n=1,2,3) .. would complete t...

can i ask for clarification.. in the example above, do i simply send both output of [l1] & [l2] into OCI. And do I need "Enable transaction grouping" ticked ? But then, if I do this, I must use "Rows per transaction" = 1 ?? Won't this be really slow ? internally in Oracle, ho...

I'd approach it as follows: 1. DSjob10 (that runs on 10th of month) - writes 1 line of completed date in the text logfile. 2. DSCheck7d - checks if it's been 7d since the last completion. This job (Job Control in Basic) - read the above file created in step1, check if system date is >= (date in step...

the job needs to insert into 2 tables with Referential Integrity constraints (ie: insert into table tCustActv must have reference to existing tCust ) (if isNewCust) [T1]-l1-> tCust (insert) [ ]-l2-> tCustActv (insert) my question is when i have new Cust record & I need to create both tCust &...

I think you can use this function:
NullToEmpty(inlink.Premium) : NullToEmpty(inlink.RATE)

Yes, I did test it from within SQLServer console & the main calling routine calls and completed all stored procs that needed to be called.. One more thing i found, in the documentation about RDBMS plug-in, in before/after SQL, it mentions that calling stored proc is NOT supported. I guess this m...

Question: when I call using EXEC StoredProc1 in After-SQL of SQLServer stage, does DataStage WAIT for completion of it ?? In my case, StoredProc1 calls 6 other storedprocs (storedproc1a, 1b, 1c...) I saw that the first 2 storedproc's ran & not the rest.. I suspect DataStage only send Execute on ...

I'm hoping there's teradata person here..
I am trying to find codes to change teradata password.
I'd like to put this in Stage-after-SQL to automatically change password into the same string to avoid password expiration.

Unfortunately, I cannot turn-off the password expiration

thanx,
HT

Unfortunately, these 2 environments are completely disconnected. I need to copy the hash files from PROD which is secured, I am unable to even create jobs there. File systems is also secured which is off-limit for me. I need to get copy of hash to diagnose when numbers don't reconcile. But I only ha...