03-06-2014 12:04 AM
I have a fields named ADDRESS, which contains varchar data of 120 bytes(i.e. Sample is shown below). I need to standardize a portion of string, for example:
#39/1, Electronic City, St. Green Glen, Bangalore
I need to convert St. to Street and rest all will be same (
#39/1, Electronic City, Street Green Glen, Bangalore
Kindly help me on this.
03-06-2014 08:42 AM
You can parse the data using the parsing node then use the standardization node with the English (India) QKB and the ENIND Address Extension Standards definition.
03-11-2014 10:01 AM
I tried it by the following way.I created a definition and selected in substring.It is working fine in sas data management studio.But while running the same job in sas data management server it is showing following error as |error|DF001|0;|2;Blue fusion error -801:invalid definition name :address>this definition may not exist in your qkb.
03-11-2014 10:06 AM
Does your server have access to the appropriate QKB? As explained in the Prereq section of this topic:
03-11-2014 10:13 AM
You may wish to have a centralized location for the QKB that both the client and server can access, rather than having two distinct installations of the QKB (which can lead to versioning issues). Check that the QKB on the server is the same QKB version that the client uses.
03-17-2014 06:19 AM
I am getting an error while inserting match codes into database output table.The error was 11: Data Access Plugin - Max. ODBC error count (500) exceeded. Last error:.My source data is having 92 lakhg records....when i try to inser match codes it is inserting only 111 records .Kindly help me on this.
Many thanks in advance.
03-17-2014 12:08 PM
What type of database are you writing to? Are you inserting records into the same table that you are reading data in the data input step? That could cause your issue. Try inserting data into a separate table to see if that resolves table locking errors. Also, can you submit the whole log file?
03-18-2014 01:12 AM
I am trying to insert into oracle database and inserting into separate table.can i set anywhere options like set define off and set scan off.
03-18-2014 07:42 AM
can you kindly suggest me how to increase cluster memory morethan 4GB.my data management server is running on 64 bit mode.I am unable to give morethan 2047 mb.When i give it to 4000mb it is prompting to enter integer 2 to 2047 .I checked in the dmserver.cfg file also.there i find cluster/bytes.
your inputs are highly appreciated.
many thanks in advance.