DSXchange

Mismatch between Oracle stage and version of Oracle database? Has Oracle been upgraded with no change to existing job?

3153 TWM Workload violation: %VSTR Explanation: This error occurs if a logon request is aborted by Teradata TWM for a Workload Limit violation. Check currently active Teradata TWM rules. Generated By: Dispatcher. For Whom: End User. Remedy: Wait for system activity to subside or contact your TWM Adm...

In Job ->

Edit - Job Properties - check box "Allow Multiple Instance"

You can now execute job "JOBNAME" with a qualified name ie:

run JOBNAME.YELLOW

run JOBNAME.GREEN

without having a datastage contention

Decimal 254
Hex FE
Octal 376

Teradata timestamp format is

2007-10-26 17:08:48

So try

RECEIPT_DT:Date=date_from_string["%yyyy-%mm-%dd %hh%nn%ss"](RECEIPT_DT).

create 2 output links from transformer. keep two rec counter stage variables, rec ctr, rec ctr + 1 to be used for sorting after transformer. Increment both rec ctrs by 2 for each input rec. for inrec 1 -> out link1 rec ctr, inrec1 data1 out link2 rec ctr + 1, inrec1 data2 sort on rec ctr field after...

Call DSExecute("UNIX", sed 's/a/b/g' < /tmp/input.txt > /tmp/output.txt , output, systemreturncode)

Floor() function works well for truncating.

In general, if needed, you could multiply/divide by desired power of 10, apply Floor() (or Ceiling() if rounding up), then multiply/divide by desired power of 10 to get the exact precision you want.

Floor() function works well for truncating.

In general, if needed, you could multiply/divide by desired power of 10, apply Floor() (or Ceiling() if rounding up), then multiply/divide by desired power of 10 to get the exact precision you want.

You need to build two addl record types (header and trailer) with layouts matching your detail rec so you can merge them to one file. You can play around with the existing columns or append new columns to do that. So you need three output links. Two of the output links (header and trailer) will need...

email me - got info for AIX, not windows though. your compiler options would be different, as well as paths to object files. - elder700@yahoo.com

To get you started: 3 fields in - Grp field, sum field, 3rd field. Sort stage: key change on field Grp field. Transformer: 3 out links, addl column rec type - 1 for hdr, 2 for detail, 3 for tlr make all rec layouts match for merge key change = 1 constraint for hdr, tlr, refresh rec ctr & sum sta...

Iconv(Field(DateandTS," ",1),"D-YMD[4,2,2]")

Sorry for the multiples. If your date format is mm/dd/yyyy 00:00:00 then yes, the timestamp will kill the Iconv. To fix, pass the date as a char, then remove timestamp (Field function - keeps first field before space in this example - look at Help) and apply Iconv: Iconv(Field(DateandTS," "...

Sorry,
convert dates as

Iconv(daten,"D/MDY[2,2,4]")