Re: strsql output

exp-s wrote: 
Hi ,
i am using sql to view records in the database which i can view without
any problem in the display, the thing is that i need to have the
records in a output file i am trying hard but there is no sql option to
direct the output to a physical file or to a printer file,
does anyone know how to redirect the output from the display to a file?
thanks


There are a couple ways you could direct output to a table (physical file) using SQL:

1) CREATE TABLE <name> AS ( select-statement ) WITH DATA
See as-subquery-clause here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmsthctabl.htm

2) CREATE TABLE <name> ...
   INSERT INTO <name> <select-statement>
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmstbackup.htm

--
Karl Hanson
.

Relevant Pages

  • Re: Querying a DataSet/DataTable in .NET
    ... to writing an in-memory database engine. ... >>>I think it would be nice if we could have a SQL engine available on the ... >>> display only (I could put it in business objects so I can reuse the ...
    (microsoft.public.dotnet.general)
  • Re: Native exception 0xc0000005 when using SQLCE and .NET CF 2.0?!
    ... Try to check out this article by Joao Paulo Figueira entitled "SQL Compact ... doesn't matter whether the database is empty or not when the test is ... SqlCeEngine sqlEngine = new SqlCeEngine( ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Increment & back page
    ... I have a database and a webpage with a table view linked to a formview to ... I would like to be able to display the number of times a particular record ... Is there an easy way of incrementing a value with SQL code or do I need to ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Treating NULL database values in classes and Form fields.
    ... A Null in SQL means in fact unused. ... When I read numeric data from a database into a class object and then ... my application the associated Form fields should then display nothing ...
    (microsoft.public.vb.general.discussion)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)