DSXchange

Hi Ray, Thats what I figured out..To use a ODBC/DB2..but while going through some previous posts I came accross a mention on ODBC.ini file so was not sure how to establish a connectivity between AS400 and DS. But I guess the DS admn will be doing that. In the mean time I am still trying to figure ou...

Hi All, Earn and learn time!! We have to create an interface between HR-Oracle database to AS400 where we will dumping some table information from Oracle database to AS400 box :roll: . Can anybody pls explain the outline/path that I should follow or where I should search for more information. Thanks...

Hey, I copied a sequence then clicked the job activities to change individual names nothing happened :( tried clicking on another job..nothing happened..then DS hung up on me. :cry: .so closed DS "cntr alt del" reopened..... all things changed previously were not savedby me...my mistake......

There is a lot of information available in this forum as well as ascential site. Bascically QualityStage would be used as a cleansing tool to investigate and standardise the data quality. Among many other features widely used it may also be used for deduplication. And as ketfos has mentined Profile ...

a hint..maybe useful maybe not..Every Mainframe file would be neccessarily accompanied with the cobol file defination. So looking into the .cfd file will help you analyse the data defination associated with the Respective column names. It might be that you are associating the defination with other f...

Hi,
Thanks. Setting the preserve partitioning to Clear helped.
Ash.

"000000000" in transformer derivation of that field..(?)

Hi, I am getting the following error when I am trying to write to a table Target: When checking operator: Sequential operator cannot preserve partitioning of parallel dataset on input port 0 I am using all defaults. Which area should i look into for this warning. Any comments will be helpful. thanks...

Hi,
Did you check if there are improper indexes on the table. Also i guess looking into transaction size and array might help..I think.

Hi Annapurna,
Also want to add a comment.. As Sai Said handle "NULL" values with care while calculating CRC32. It does not like NULLS.
If Date fields are coming in try the NullToEmpty (Courtesy ADN) or for integers coming in as Nulls NullToZero should work. Am I correct Sai?
Thanks,
Ash.

Hi,
Thanks!! actually i checked and re checked there is no mismatch at all. Trust me....well.. I am not believing myself..this thing ate up half of my day..Anyway I reloaded the metadata and Bingo problem solved ..Its frustrating though. because i still dont know what had happened.
Thanks Ash.

Hi All, I am getting ORA01008 when running a server job. I checked into the column names to see if there is a mismatch over there. No mismatch. The exact error is: ORA-01008: not all variables bound" Not sure where else to look into to track this error. Any comments would be helpful. Thanks, As...

Hi, I got it..Thanks anyways..I was writing to an ODBc stage and dint check the array size over there.. Ash. Hi All, I am getting an error as follows while compiling... "Internal Column Storage exceeded, limit is 8192 items ,reduce specified array size(Transformer name)" I am using DRS sta...

Hi All, I am getting an error as follows while compiling... "Internal Column Storage exceeded, limit is 8192 items ,reduce specified array size(Transformer name)" I am using DRS stage. I had a LongVarchar column of length 1200 I reduced it to 250 also I made array size=1...error persists. ...

Thanks Ray...I will try using smaller array size..

ray.wurlod wrote:No.

There is no fix to this from DataStage apart from using smaller transactions.

Otherwise you have to negotiate with your DBA for a larger undo tablespace.