DSXchange

What is the use of understanding the operators behind the stages? Will the syntax given in the Parallel Job Advanced Developer Guide will be useful in any ways?

How many nodes are in your APT_CONFIG file? Also, if you aren't changing the number of nodes between the transform and output dataset, no collection will take place so the data will, of necessity, be in the same order each run. There are four nodes and I configured the last dataset in sequential mo...

I have designed two job,which has four stages. JobA : Oracle->(Partition Method : Round Robin) Sorter->Transformer->(Collection Method :Sorted Merge) Dataset JobB : Oracle->(Partition Method : Round Robin) Sorter->Transformer->(Collection Method :Round Robin) Dataset The output (order of the data) a...

When i invoked a parallel routine in my datastage windows server as $APT_COMPILER $APT_COMPILEROPT InputProg.c -o OutputProg.o Where APT_COMPILER = cxx APT_COMPILEROPT = -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c I got the following error. cxx: file 'C:/PROGRA~1/MKSTOO~1/etc/cxx.ccg': The system canno...

ray.wurlod wrote:Moderator: please move to Parallel forum

HH:MM:SS.ssssss

Thanks Ray & sorry for making it in wrong forum

The elements HH:MM:SS can be fitted in 3 bytes as such the YYYY-MM-DD is fitted in 4 bytes. Then how does the the time data type occupies the 5 bytes in memory?

YY YY MM DD
Byte 1 Byte 2 Byte 3 Byte4

HH MM SS
Byte 1 Byte 2 Byte 3

Can any one help me in explaining this?

Many Thanks
MSR

Neither SHLIB_PATH nor LD_LIBRARY_PATH should be set to a "bin" directory, but rather need to be set to a "lib" directory. And you set one or the other, depending on your O/S, never both. HP/UX uses the former from what I recall, but it can depend on the chipset I believe. Been ...

No spaces around the "=" characters when setting variables. You probably also need to export the variables. Yes. I have removed the spaces and exported them. But there is no use :( What flavour of unix are unix are you using ? v10.24 Do you have the directory /opt/app/Ascential/DataStage/...

Set these: export APT_ORCHHOME=/opt/app/Ascential/DataStage/PXEngine. & export APT_CONFIG_FILE=opt/app/Ascential/DataStage/Configuations/default.apt in the working directory where you are running the command. Setting the APT_ORCHHOME & APT_CONFIG_FILE doesn't help me come out the error mess...

When I invoke the 'orchadmin check' command, I got the below error /usr/lib/hpux64/dld.so: Unable to find library 'liborchgeneralhpia64.so'. Killed After a search in this forum I tried setting the below three environment variables & executed the same 'orchadmin check' command. But there is no us...

mgendy wrote:Does the table contains any previous data ? or it is empty ?

It is a empty table

mgendy wrote:Does the table contains any previous data ? or it is empty ?

It is a empty table

The syntax from SHOW Table is below What column is the primary key defined as in Teradata CREATE SET TABLE DEV01VHA.emps ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( employee_id INTEGER NOT NULL, first_name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, last_name VARCH...

20 rows received must be 1 row duplicated 20 times M.Gendy No the rows are unique. The rows are not eliminated for that reason. My Non unique primary index(default as it is the first column) is employee_id and I have loaded 20 unique primary index records. Please find the data snapshot below 100,St...

We have a teradata API stage inserting records in to it. On any run, it insert only the last row! Below is the log output APITarget: Number of rows received = 20, rejected = 0, inserted = 1, updated = 0, deleted = 0 Is there any know issues we have in Teradata API stage. Please help Many Thanks MSR