DSXchange

How do you know you're processing the correct level of delimiter? For example Char(252) is - probably - a sub-value mark, while Char(253) is - probably again - a value mark. Some operations, such as Trans() with a multi-valued first argument, effect an automatic Lower() on the dynamic array. Add de...

For the sake of our sanity, can you explain in words what this routine is meant to accomplish / return? I really don't want to infer anything based on a reading of the code. What i am trying to do is get the position numbers for a given multi-valued column. Eg: Arg1 = (ABC~DEF~GHI~JKL ) Then i want...

Hi All, I keep getting this following error in all the jobs in Production Box. "DataStage Job 2085 Phantom 14940 Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used." I got a patch "Ecase 99919" which was described in one of the forums. ...

I made 2 changes to the job. Existing Job included - OCI Stage to Transformer to ODBC(AS400). 1st Modification: Added a flat file such that the records sent to ODBC are sent to Flat file too. 2nd Modification: Added another flat file such that Load to ODBC then to Transformer and then Flat file. The...

Katie09 wrote:Check this site :-

It contains good material abt oracle..

http://www.orafaq.com/wiki/SQL*Loader_FAQ

hope this helps..

This one gave me the answer i was looking for when faced with multiple SDF loads using SQL Loader. Not much in ways of examples but got my work done.

Katie09 wrote:Check this site :-

It contains good material abt oracle..

http://www.orafaq.com/wiki/SQL*Loader_FAQ

hope this helps..

Thanks a lot. Works for me!!!!

ray.wurlod wrote:Ask Tom is an excellent resource for Oracle questions.

I saw this message on the site:
"Sorry I have a large backlog right now, please ask a question later." Any other ideas would be appreciated.

Hi. I am trying to load data using SQL Loader to a Nested Table. I have gone through the control file examples in Oracle and its not been a help at all. The Short comings of the Oracle guide are: 1. what is the best way to load a parent table with multiple child tables? 2. How to lead Variable Lengh...

1. You tell us, is your problem resolved? :? If so, you should do two things - post the resolution and mark the problem as Resolved using the green button at the top of the screen. 2. Ideally, by looking at the thread subject - it should either be marked 'resolved' or 'workaround', otherwise a 'wor...

Ok, if I were you, I would do the following: - Bring the job down to another env., delete the table and reload. - Check for before/after job subroutines, before/after stage subroutines, job control section of the job, before/after tab of the database stage. - Make sure I am looking into the right e...

No, my experience is all with Oracle for the last several years, with Progress and Informix before that. I've got no idea about any quirks that DB2 may bring to the table or how they line up with Oracle. For example, in Oracle an update or delete that affects zero records is considered successful w...

When i said monitor, I asked you to see the no. of records extracted from source and loaded to target. Right click the job in Director and select monitor. Then you can see the details. If there is a difference between source count and target count, then you might have to check SELECT sql in source ...

This was the next step that i checked and i even loaded the data into a flat file to analyze it. I did a one time load for the missing 41 records and even then those records in ODBC were not updated at all. DataStage showed that it has successfully loaded all records. When you say 'missing 41 recor...

Why assume that it is DataStage? DataStage reports the number of records it sends to the ODBC driver. It may be the ODBC driver, it may be the interface into the AS/400 environment, it may be in the tables themselves where the problem occurs. What i would like to know is how do i test the ODBC driv...

SQL is: Insert into Table Name(Col1, Co2......Coln) Values (?,?,?....?) With None; With none what? :? I assume this was a system generated SQL which was modified when User-Defined SQL was selected. It was always there, totally unchanged.. As i keep stating, i did not touch the job in Production. Ho...