DSXchange

hello, My source is DB2 running on AS 400 and staging/target is DB2 runnin on AIX. Ascential is running on WIndows. There is a job that pulls data from source and loads the staging table. The problem is that though there are no duplicate rows in the source I get the unique key violation error. If I ...

Hello, I am trying to truncate a table using the DB2 import command (importing an emprty file into the table) The command works fine at the Command Center and Db2 prompt. But when I try to run it as a "before SQL" statement I get this error : [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpe...

You ran out of disk space, and yes the job fails to blow up. Just kill it. You mean the job just shows that this is writing the data but it isn't ? Maaan that is bad news .. I just saw the disk space - infact the size is constantly increasing... if the disk space is full - y is the size increasing ...

hello, I am getting this warning when trying to write to a hash file. add_to_heap() - Unable to allocate memory But the job continues to run (The table has about 18 million rows) - It gives me this warning but continues load rows into the hash file. Can any1 shed light on this - this is on an AIX ma...

Thanks Oniel and others.
I am using this command to truncate the table.

import from <empty file> of del replace into <table name>

Thnks
-Xan

hello I am facing this problem.... I have to pull 40 million rows from source into staging.(full refresh) (In earlier run, it inserted around 20-25 million rows and aborted..communication error..) Now I have to remove those existing rows and insert all the 40 million new ones... I have the following...

Thanks VMC and Chulett.. I had to go not to uninstall but also go into the registry and remove all references to Ascential then reinstall client software and then it works. Infact jsut to be on safe side i logged into server thru telnet and cleared all the locks and stuff.. Yeah, I run Windows XP wi...

Hello.. Now I have a really weird DS interface problem. If I login into DS Designer the main GUI interface doesn't showup but I see only the "new" window popup (the window that allows you to create New server job,sequence etc..)..if I try to open an existing sequence/job the system just st...

hello all. I am using ODBC stage for DB2 on AS/400 There is a column colA of length 2 in the source ..say it has value 'AB'.. there are 104 rows.. when the ODBC loads the data.. it loads 'AB................................." (186 characters) into that column (i am trying to see the data loaded ...

If, in the Transformer stage, you identify colB as key, it goes into the WHERE clause - you don't need to provide any mechanism for returning it. It's a perfectly legitimate to "lie through your teeth" to DataStage about what the key column is; it simply means the search key, whether that...

Hi Xnadu, What is the exact requirement? Is it to be able to make a lookup to a table using the following query: select max(colA),colB from table A where colB=<some value> Try this: In the same job load a hash file using the following query: select colB, max(colA) from table A group by colB with co...

Currently, only the ODBC and UV stages support multi-row returns from reference lookups. Read the on-line help topic Defining Multirow Lookup for Reference Inputs . --> Thanks for ur input Ray.. I know that only Universe and ODBC stages return multiple rows.. but I just want to return a single valu...

Thanks for ur response Sumit. but no it doesn't work. My database is unable to recognise the ":" symbol when I use the user defined SQL...I guess when i say user defined SQL, DS "passes the the query directly to the database...." As I said the same query that is "generated&q...

Ray, "The assumption is that, in a reference lookup, you're retrieving one row, so that GROUP BY, HAVING and ORDER BY are irrelevant." --> Consider this query select max(colA),colB from table A where colB=<some value> If I have to put this query in the reference table I need a group by on ...

Hello all, in DRS stage the "other clauses" box is grayed-out (uneditable) But i see some existing EPM jobs with contents in that box. Is there any work around .. (I searched Ascential Knowledge base and found similar problem existed in Oraoci stage and was fized in 5.1.1 - Case : G36262) ...