Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: RE: RE: using ? in "in"

Posted By: Art Kagel
Date: Tuesday, 12 October 2010, at 10:16 a.m.

In Response To: RE: RE: using ? in "in" (Wyza, Jonathon)

Correct.
On Oct 12, 2010 10:00 AM, "Wyza, Jonathon" <wyzaj@bethelcollege.edu> wrote:
> When I delete the file it will then erase the data from the table then as
well
> (it's a true link then, not an import)
>
> Jonathon Wyza
> CX & CBORD System Administrator
> CX Programmer/Analyst
> Administrative Computing
> Bethel College
> (574)-257-3381
> AIM: Iamwyza
> jonathon.wyza@bethelcollege.edu
> ==============================
> SLES 11x64 & IDS 11.50.FC6
>
> "Don't document the problem, fix it."
> - Atli Björgvin Oddsson
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, October 11, 2010 8:05 PM
> To: ids@iiug.org
> Subject: Re: RE: using ? in "in" [21631]
>
> Naw, it's simpler than that. The underlying file that an external table
maps
> into the data doesn't actually have to exist, so, all you have to do is
> include a file or run identifier in the file's records and map the table
to a
> wildcard representation of the filename(s). Then multiple jobs can map in
> their own files and in the IN clause sub-query select .... where jobid =
> myjobid. So the external table would be defined as something like:
>
> create external table value_lists (
>
> jobid int,
>
> value_id in
> )
> USING ( FORMAT DELIMITED DELIMITER ''|' ) DATAFILES (
> DISK:/value_files_dir/value_file.%r(1..99999));
>
> Now each job can create a file that has lines like:
> <jobnum>|value1|
> <jobnum>|value2|
> .....
>
> and name the file /value_files_dir/value_file.<jobnum>
>
> and the IN clause looks like:
>
> ..... IN (SELECT value_id FROM value_lists WHERE jobid = <jobnum>)...
>
> After the job completes just delete, move, or rename the job's values file
and
> IDS won't know that it exists anymore. Existing jobs that have the file
open
> will still see its data, but since the records in that file don't contain
the
> other job's jobid they won't see the rows in there anyway.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors
> (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other

> organization with which I am associated either explicitly, implicitly, or
by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Mon, Oct 11, 2010 at 7:44 PM, Wyza, Jonathon
> <wyzaj@bethelcollege.edu>wrote:
>
>> That might work, except it appears that external tables are not
>> capable of being temporary and must have unique system wide names.
>> Since this process has the capability of being run more than once at a
>> time then that could present problems. Beyond that I'd have to make
>> sure it was dropped after the process finished. Obviously i could use
>> a begin_work statement (and thus if the program exited then it would
>> rollback), but then it would log all the work, which i really don't
>> need it to do.
>>
>> Jonathon Wyza
>> CX & CBORD System Administrator
>> CX Programmer/Analyst
>> Administrative Computing
>> Bethel College
>> (574)-257-3381
>> AIM: Iamwyza
>> jonathon.wyza@bethelcollege.edu
>> ==============================
>> SLES 11x64 & IDS 11.50.FC6
>>
>> "Don't document the problem, fix it."
>> - Atli Björgvin Oddsson
>>
>> ________________________________________
>> From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of John
>> Miller iii [miller3@us.ibm.com]
>> Sent: Monday, October 11, 2010 6:52 PM
>> To: ids@iiug.org
>> Subject: RE: RE: using ? in "in" [21628]
>>
>> Have you considered external tables? This does require the
>> load/unload=
>>
>> file to be
>> accessible from the database server.
>>
>> John F. Miller III
>> STSM, Embedability Architect
>> miller3@us.ibm.com
>> 503-578-5645
>> IBM Informix Dynamic Server (IDS)
>>
>> ids-bounces@iiug.org wrote on 10/11/2010 01:54:26 PM:
>>
>> > [image removed]
>> >
>> > RE: RE: using ? in "in" [21624]
>> >
>> > Wyza, Jonathon
>> >
>> > to:
>> >
>> > ids
>> >
>> > 10/11/2010 01:54 PM
>> >
>> > Sent by:
>> >
>> > ids-bounces@iiug.org
>> >
>> > Please respond to ids
>> >
>> > True, but it seems faster in perl to do this:
>> >
>> > INSERT INTO temp_table(id) VALUES (list of values that goes to
>> > charac=
>> ter
>> > limit); #run until we run out of values
>> >
>> > Than to do this
>> >
>> > While(list of values)
>> > INSERT INTO temp_table(id) VALUES(value)
>> >
>> > I'd pay good money for the load from file to not be a isql/dbaccess
>> > only thing and to work in DBI.
>> >
>> > Jonathon Wyza
>> > CX & CBORD System Administrator
>> > CX Programmer/Analyst
>> > Administrative Computing
>> > Bethel College
>> > (574)-257-3381
>> > AIM: Iamwyza
>> > jonathon.wyza@bethelcollege.edu
>> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3
>> > D=
>> =3D=3D=3D=3D=3D=3D=3D
>> > SLES 11x64 & IDS 11.50.FC6
>> >
>> > "Don't document the problem, fix it."
>> > - Atli Bj=F6rgvin Oddsson
>> >
>> > -----Original Message-----
>> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>> > Of=
>> Art
>>
>> > Kagel
>> > Sent: Monday, October 11, 2010 4:14 PM
>> > To: ids@iiug.org
>> > Subject: Re: RE: using ? in "in" [21621]
>> >
>> > 64K actually. But putting the list of values into temp table also
>> > sol=
>> ves
>> the
>> > max statement length problem.
>> >
>> > Art
>> > On Oct 11, 2010 3:26 PM, "Wyza, Jonathon" <wyzaj@bethelcollege.edu>
>> wrote:
>> > > Nah, the problem is the limit in the size of the string. I was
>> > > hopi=
>> ng
>> > > to
>> > get
>> > > around the 32k character limit.
>> > >
>> > > Jonathon Wyza
>> > > CX & CBORD System Administrator
>> > > CX Programmer/Analyst
>> > > Administrative Computing
>> > > Bethel College
>> > > (574)-257-3381
>> > > AIM: Iamwyza
>> > > jonathon.wyza@bethelcollege.edu
>> > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>> > > =3D=
>> =3D=3D=3D=3D=3D=3D=3D
>> > > SLES 11x64 & IDS 11.50.FC6
>> > >
>> > > "Don't document the problem, fix it."
>> > > - Atli Bj=F6rgvin Oddsson
>> > >
>> > > -----Original Message-----
>> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>> > > =
>> Of
>> > > Walt
>> >
>> > > Hultgren
>> > > Sent: Monday, October 11, 2010 3:07 PM
>> > > To: ids@iiug.org
>> > > Subject: Re: using ? in "in" [21617]
>> > >
>> > > If you know the number of values, either by program logic or by
>> > > collecting
>> > and
>> > > scanning user input, you could build the query string with the
>> > > appropriate
>> >
>> > > number of question marks before it's prepared.
>> > >
>> > > Walt.
>> > >
>> > > On Oct 11, 2010, at 2:54 PM, Art Kagel wrote:
>> > >
>> > >> You can but you need one for each item in the list. You can't
>> > >> just=
>>
>> > >> use one ? for the whole list. For a variable length list use a
>> > >> tem=
>> p
>> table.
>> > >>
>> > >> Art
>> > >> On Oct 11, 2010 2:34 PM, "Wyza, Jonathon"
>> > >> <wyzaj@bethelcollege.edu=
>> >
>> > >> wrote:
>> > >>
>> > >> --00163630ee9fdea2c004925be309
>> > >>
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>> >
>> **********************************************************************
>> *=
>> ********
>>
>> >
>> > >> Forum Note: Use "Reply" to post a response in the discussion
>> > >> forum=
>> ...
>> > >>
>> > >
>> > > --
>> > > Walt Hultgren
>> > > walt.hultgren@emory.edu
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> **********************************************************************
>> *=
>> ********
>>
>> >
>> > > Forum Note: Use "Reply" to post a response in the discussion
>> > > forum.=
>>
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> **********************************************************************
>> *=
>> ********
>>
>> >
>> > > Forum Note: Use "Reply" to post a response in the discussion
>> > > forum.=
>>
>> > >
>> >
>> > --000e0cd30b74875c6d04925cfe58
>> >
>> >
>> >
>> **********************************************************************
>> *=
>> ********
>>
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>> >
>> >
>> >
>> **********************************************************************
>> *=
>> ********
>>
>> > Forum Note: Use "Reply" to post a response in the discussion forum.=
>>
>> >=
>>
>>
>>
>>
>
>
*******************************************************************************

>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>
>
>
*******************************************************************************

>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> --000e0cd157441dbae704926038dd
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>

--00163630f627dbc10904926c1e00

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.