DSXchange

Hi
I guess i m facing the same problem ...
Open your xml with Ultraedit You gonna see some garbage char before "<xml version="1.0">"
if you remove them it should work
Michel

ALL, I did notice some of the tables data is in EBCDIC format on AS/400, i am using DB2 stage to connect to As/400,please let me know where to define EBCDIC definition in DB2 stage properties or is there a way to convert this EBCDIC format data in transformer.. Thanks in advance.. Hi Edward, Get th...

Hi Antika,
I'd better use sql*loader rather than a straight sql statement !
Especially if you have millions records
All the best
M.

Hi,
I guess You're trying to load a terradata tables isn't it ?? If so did you set "-sessionsperplayer" and "-requestedsessions " as DB options ???
All the best

Hi
Use as an Out_format
something like %G

All the best

Are you sure it s a DS problem ???

/usr/lib/dld.sl: Can't find path for shared library: libUtilWSClient.sl
/usr/lib/dld.sl: No such file or directory

DS doesn't use anything in /usr/lib I guess

hi,
You must "source" the dsenv first

hi
PX is running on UX only (including some linux version i guess) if you install everything on your windows system, you will be able to "display" PX jobs but no compilation or exec that's all.
In addtion you need a C++ compiler on the ux box
all the best

Hi, Datasets are the most important thing to understand to start anything within PX, you should attend a PX training before. The Datasets are the "magic key" to handle scalability. in addition all the partionning stuff is based on them. Don't forget that Flat files aren't so "popular&...

Hi,
Really simple since the version 7 use copy and paste !
All the best

PX and TD are great working together !!! it's probably the best configuration you can have. Performances are really impressive ! Obviously you will need some hints around PX/TD like timestamp support or # of multiload sessions. Bteq (TD "PL/Sql") is really a nightmare to maintain. PX is re...

it's an Oracle Pb, try to redesign your query by using explain plan or ask DBA assistance
(Try explain plan first)
All the best

Hi,
If you use "Load" as a "write method" you have in the "options"/"Index mode" several options to rebuild, maintain etc ... indexes
All the best

Hi
Time compilation is long if you re using a transformer try the switch/filter/modify instead
All the best
l homme

Hi,
Be really careful using TD
It s mandatory to add cnx option
Numbersessionsof players etc ...
All the best
L homme