Clearspace Recent Blog Comments Syndication Feed

RE: Deployment

jfeinsmith — Tue, 01 Dec 2009 05:39:16 GMT

Mike,

Good to hear from you. Last time I was down by Fort Gordon, I walked onto the 7th green and shook hands with Arnold Palmer during a Masters practice round. Bet you can't guess the year!

Anyway, if you stop by ATL before heading off for combat skills training, let me know. Dinner, beer and cigars on me!

Warmest regards,

Jeff

RE: Select data from table insert into flat file...

sansanjuan — Fri, 06 Nov 2009 22:21:29 GMT

Or to land on a PC

CREATE EXTERNAL TABLE 'c:\temp\pc_example.csv'

USING( format 'text'

compress false

delimiter '|'

remotesource 'odbc'

)

select 1 anchor,decm_code,replace(condition_status_description,';',',') etg_desc from foo_etg_icd9 where lower(etg_desc) like '%diabetes%'

RE: Select data from table insert into flat file...

dbirmingham — Tue, 20 Oct 2009 15:29:50 GMT

more spontaneously, try:

nzsql -d mydatabase -A -q -t -c "select * from tablename;" > flatfilename.dat

RE: Happy Belated Birthday Oracle Exadata (aka Database Machine)

edge_dave — Thu, 01 Oct 2009 12:36:31 GMT

You were definitely right re the performance ads being commissioned Tim - see http://www.theregister.co.uk/2009/09/29/tpc_slaps_oracle/

Maybe a bit to quick for their own good?

RE: Change, but no Change

Scott_Schweitzer — Thu, 27 Aug 2009 21:10:27 GMT

What role do intelligent programable processor based 10Gb Ethernet NICs play in the above design? We're talking about NICs that can easily steer traffic to various host memory or processor cache buffers via OS bypass. Wouldn't this move them from outside the snippet processor to inside it? How might this improve performance for Netezza?

RE: Select data from table insert into flat file...

jskarioki — Tue, 25 Aug 2009 22:35:05 GMT

To create a text-format external table, enter:

CREATE EXTERNAL TABLE extemp SAMEAS A USING (DATAOBJECT ('/tmp/a.txt'));

To unload data in user table A to the external table EXTEMP, enter:

INSERT INTO extemp SELECT * FROM A;

RE: Sync problem from SQL Server to Netezza

bmasna — Fri, 21 Aug 2009 05:15:47 GMT

I had same problem when loading data from SQL server to Oracle.As you already know this happens due to windows and UTF8 charset. So, here is what i did to fix issue. normally we create external table for the file in Oracle using "RECORDS delimited BY newline CHARACTERSET WE8MSWIN1252 " in ORGANIZATION EXTERNAL options.

Then do below, to read properly,

select cam_name,CONVERT(cam_name, 'WE8MSWIN1252','AL32UTF8' ) from ext_table

Convert will do the trick and all international characters get loaded properly. you normally find problems with chinese/japanse/indian characters. hope this helps.

RE: Sync problem from SQL Server to Netezza

sriband — Tue, 18 Aug 2009 13:30:56 GMT

first of all thanks for your reply.

RE: Sync problem from SQL Server to Netezza

hemantagarwal03 — Tue, 18 Aug 2009 04:25:19 GMT

I am agree with Shawn, this problem is due to mismatch of charachter set.

RE: Sync problem from SQL Server to Netezza

shawnkfox — Mon, 17 Aug 2009 20:19:36 GMT

The blog is not the appropriate place for this question, but most likely your issue is that you are using the Windows-1252 character set in your SQL-Server database. Windows-1252 has a subset of characters which do not map to other more standard character sets and you'll have to replace them with spaces or write some manual code to translate the characters to UTF-8. In the future you should make sure to configure SQL Server to use a standard character set such as UTF8 instead of Windows-1252 and you will not have this type of problem.