DSXchange

Ray, Interesting observation about MNEMONIC-1...but how would one get their flippers on that character set if they do not have it.. Is it just a matter of installing it onto the NLS server? ..and if I understand fully, NMEMONIC-1 would be considered a superset of ISO8859-1 and UTF8 ? By using this I...

Additional insight as I continue to explore..

I find that the NLS code "MNEMONICS" seems to work for both...but I am reluctant to use this because :

a) I am not familiar with it (never heard of it, actually)
b) the standard at my client for QA and higher is ISO8859-1

In fact, I already did that, and testing seems to indicate it is working.

You better be careful, Ray. People might start to think you know your stuff.



Thanks

Wade

The version installed at my client is 7.5.1.A

RE: Workaround, yes - I did exactly that - I typed in the name of the routine.

It is working now, but it does appear to be a bug...

Thanks, guys.

w

Hlo. I can see all the routines supplied with DS in the repository, but within a job field transformation, only certain routine categories are visible. for Example...within the SDK, I would like to use KeyMgtGetNextValue within KeyMgmt. However, only Date is visible :shock: . ...is this some kind of...

Hi, Thanks for your reponses. In short: - I have increased the transaction size in the Oracle stage to 2000, which has substantially increased throughput... - There are NO interesting user functions - I have already landed the data - I was thinking also it might be best to break the flow to see the ...

Hello, all, I have a simple (like...SIMPLE) job : ORA8 -->IP-->TF-->SEQ-->IP-->ODBC takes 10 attributes from an Oracle DB, passes through a transformer (no transformation) then writes to a sequential Staging point, then writes to AS400 via ODBC. the AS400 record is a bit long, but not unusually. 58 ...

Hi, Craig,

Yes, if the 160 MB file is removed, it runs like always...this is why this is so bizarre...

thanks...in-process with IBM...

Hi, Craig here is the log entry: From previous run DataStage Job 228 Phantom 20690 GET_EXT_LIST..ExtractKey: DSD.StageRun Active stage starting, tracemode = 1. GET_EXT_LIST..ExtractKey: DSD.StageRun Active stage starting, tracemode = 1. GET_EXT_LIST..ExtractKey: Set NLS locale to US-ENGLISH,US-ENGLI...

Hi, all, We have a simple job accessing a Folder stage, extracting only file names (using a substrings command on the file name with a len-20 as the second value) and writing this to a hash file. There are about 10 files in the folder. This job has been running for some time successfully. However, o...

When I receive that warning, it means that DS has automatically dropped the library name from the query..and when it does this, I get: EXTPTP003createtabletests2..ODBC_34.LK_Create_Table: DSD.BCIOpenW call to SQLExecDirect failed. CREATE TABLE PURS8167(...<Field names>...) SQLSTATE=S1000, DBMS.CODE=...

Thanks for the comment...tried it, and at least I didn't get my table name in quotes...however, still have the same problem: Fully-qualified table names are not supported in DDL statements [BICF00D/PURS8167]. Using Un-qualified name. And also am still getting the same error, though the SQL is very s...

I have an interesting problem. I am trying to drop, then create/recreate a table in AS400 from a flat file. This should be a very simple job. We make the connection through ODBC to AS400, and pass user name, pwd, odbc dsn, Environment, library and table name as parameters Example DDL: CREATE TABLE #...

What do you mean by "Distinct site codes".. and how is your source file stored.. Pretty simple, actually...a "site code" is numerical. There are different sites. So there is a number of different, distinct numerical codes that I need to extract from the file, then provide as par...

What i got frm ur question is how create target tables based on input site names.. Thanks, but I am not sure that is quite it... I need to create and load one table for each "site", with naming of each by parameter (for example, <schema>.<name>#SITE#) these tables may or may not be create...