DSXchange

Is "ACCOUNT_NO" the first column in the file? The data shown, {c4 c4 f2 f0 f0 f9 ` f1}, is EBCDIC for "DD2009" for the first 6 characters and that does not equate to what a COMP-3 numeric should look like. The "2009" could be part of a PIC x or PIC 9 date field, though...

Hi I am using a complexfile to read ebcdic data and passing it to the sequencial file by converting ASCII in transformer stage. Complexfile---> Transformer--->Sequencial file When i am runng the job all columns are passing through (converted to ASCII). but having a warning (below) in source. EbcdicD...

Hello Just need a small clarification... I have a field (lets suppose COL_A) which is of CHAR data type. I changed it to VARCHAR in a later stage. Now if i am passing a values with leading or trailing zeros and using trim function[TRIM(COL_A)] on it, then what would be output of COL_A. Is the leadin...

Hi,


It seems i have an issue with scratch space issue.
Can anyone let me know how to check scratch space size.
APT_BUFFER_MAXIMUM _MEMORY is the right variable?

Thanks

Hi, I am using a shared container in a Job. In the shared container the source file is taking from a shared path and doing the sort in sort stage on next stage. After job running some time when i saw the monitor through DS director its showing some 32670000 no. records reading to sort stage in conta...

Hi, I am using a shared container in a Job. In the shared container the source file is taking from a shared path and doing the sort in sort stage on next stage. After job running some time when i saw the monitor through DS director its showing some 32670000 no. records reading to sort stage in conta...

Hi, I have a query in lookup stage like select A,B,(MIN(D)+ORCHESTRATE.D) from TABLE where <jon conditions>....... Generated query is like select A,B,(MIN(D)+?) from TABLE where <jon conditions>....... Error log is saying "[IIS-CONN-TERA-005004] RDBMS code 3706: Syntax error: parameter token '?...

Hi, Just need to clarify a small confusion. In extraction Job i am extracting records form DB2 stage to dataset (writing through auto partion), the same dataset i am using in next Transformer job/Look-up job. Generaly, we clear the partition in Transformer job/Look-up job while reading. 1:Could you ...

Ray:- Drag and drop is ok till the number of component to move is less. If its a huge number then i think it would be a tidious task. Any other suggestion. You can use drag and drop in the Designer client. I am not aware of any version 8 programmatic method for changing the repository folder in whic...

So is there any other way, this requirement can achieve in DS V8

ray.wurlod wrote:As noted elsewhere recently, the local repository is not used for table definitions at all. They are always in the unified respository in version 8. ...

This is a very simple job. The job having a source file and a reference Teradata stage used through transformer. source file------>Transformer-------->hashfile ^ | | Teradata stage i am getting an unfamiliar error like "The AMP Lock table has overflowed". What does it mean, is this error r...

From my memory below is the formula which usually give app. Array size and Transaction Size. Array size = (Pagesize - 64) / (Rowsize * 1.1). 8192 Bytes = pagesize for DWH 4096 Bytes = pagesize for Mart. Also transaction size is calculated as Transaction size = Pages per Extent * Array size DWH table...

Hi,

Manytimes we use 'rAbortOnWarnings' (job properties) for aborting the job on getting error. Samething we can do by putting a rAbort routine in sequence.

Could anyone let me know on performence point of view which one is better and why.

Thanks
S.K

Hi Naveen, You mean to say it will execute in below order? $DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->$DB2_DATABASE-->$APT_DB2INSTANCE_HOME.... Please let me know if the above is correct? Hi, Can anyone help me to understand below elements in DB connection in datastage $DB2_CLIENT_INSTANCE_NAME $APT_...

Hi,

Can anyone help me to understand below elements in DB connection in datastage

$DB2_CLIENT_INSTANCE_NAME
$APT_DB2INSTANCE_HOME
$DB2_SERVER
$DB2_DATABASE

How all are different from one another.While database connection in a job, how all these perform in which order?

Thanks