DSXchange

Hi, Have created a very simple Stored Procedure to hit a Terradta dbase on SQL Assistant V12. ON SQL Assistant the SP works fine when called. I am no however trying to call from Datastage using the SP stage and get ... 'RDBMS code 5510: Invalid session mode for procedure execution'. I assume I must ...

Hi, Have a very simple job extracting a few rows back from a teradata dbase table using the connector stage. I have this same job running from one aix client without issue. On another sister client however, running against the same dbase environment/table, the same job fails with .... 'RDBMS code 22...

Arnd, I have cut the volumes down from 15 mill to 3 mill and the data and overflow files are exactly the same on both 8.7 and 8.1 test runs. The job run time is twice as long (ran these jobs a few times) on 8.7. Its about 8,000 rps on 8.7 and 14,000 on 8.1. The startup time on the 8.1 job seems to b...

Never got far enough to see the full results because of the time it was taking on 8.7 - I will run a test with a smaller volume.

Hi Arnd - long time no speak (its Rich Q in the UK). How goes the sailing?

Yeh when they were first created the files did match.

Am currently running some performance testing in preperation for a migration from 8.1 aix to 8.7 linux. I am running a very simple test Server job to populate a 64 bit hash file with several million rows. The same job with the same data and hash files created with same settings perform very differen...

Actually its Ed (you know the one you worked with whom taught you all you know :D ) Actually resolved this finally - but had to copy the original jobs delete the originals rename the jobs back compile and run So they get assigned new job numbers , repository objects etc And came out as proper displa...

Thanks - sorry was using it as an example - as the actual fle is a bit more complicated datawise - also I typed it wrong should have been 123{

However this was the output after conversion via dd comand

Hi - dont know if anyone can help but have a strange issue that cant understand Have a simple job that writes to a CFF stage (PX) as follows (EBCIDIC file on AIX env) FIELD A - DISPLAY NUMERIC (4) FIELD B - CHAR (3) FIELD C - CHAR (10) On one enviorment (Dev) it creates the file as expected e.g. 123...

Glad you sorted your issue out - but - one word of warning with sql assistant. There is an option somewhere (preferences I guess) - that enables the use of ODBC extentions and is enabled by default. This can cause different results when running stuff via SQL Ass vs BTEQ. We fell over this when tryin...

Hi, dont know if anyone can help - but have a job that basically needs to write an EBCIDIC file as follows Multiple records of the following type REC_TYPE(D) ACCOUNTNUM VALa VALb VALc VALd Followed by a single checkrecord of type REC_TYPE(T) ACCOUNTNUM COUNT FILLER However this scenerio is repeated ...

Hi, I have a simple buildop that uses a bit of C++ to manipulate a APT_String I am trying to work out how to trim the string of whitespace before I do my munging on it and cant for the life of me work out the proper syntax tried various combinations such as tssid_strip=INPUT.TSSID.trimWhitespace(); ...

On teradata the term database is a bit more like a schema in DB2 / Oracle - i.e same physical database instance - but in a different location within that database. This is a bad analogy but havent much time - however when querying a table you would type select * from <database>.<tablename> - and it ...

The DSJE_TIMEOUT error is because when a Datastage job is invoked the 'calling process' expects a handshake back to say it has started running, and by default expects this reply in 60 secs When the box is busy (or when a lot of jobs kick in at same time) - the engine can get overloaded a bit - and s...

it may be worth checking if the dataset did get written too at all - check the size of the dataset files in the .../DataSets directory reason I say this is that hit a problem some years ago where our dataset portions were throwing up a simalar error and after checking diskspace and filelimits on the...