Excel validation.

Hi,

Is there a simple way of retreiving a single record from DB2 file with
Excel based on row/column value.

Thanks.

This may work: Configure an ODBC connection. Start Excel. Click menu
Data/Import External Data/New Database Query using your new ODBC connection.
Then write the SQL necessary to get your one record.

Sam

<I_am_fitz@hotmail.com> wrote in message
news:1181236117.328201.202220@p47g2000hsd.googlegroups.com...[color=blue]
> Hi,
>
> Is there a simple way of retreiving a single record from DB2 file with
> Excel based on row/column value.
>
> Thanks.
>[/color]

That does work, I use it all the time.
I also make the use a parameter in the SQL and link it to a cell in
excel and when that value changes it can automatically refresh the
data.

The way to do that is to click add criteria and slect your column and
for your value type in [?]

For example, this SQL uses IBM sample customer file included in
library ADTSLAB.
You could just copy and paste this by pressing SQL button.

SELECT CUSTOMER.CUSTNO, CUSTOMER.CUSTNA, CUSTOMER.REPNO,
CUSTOMER.CONTAC, CUSTOMER.CPHONE, CUSTOMER.CFAX, CUSTOMER.CADDR,
CUSTOMER.CCITY, CUSTOMER.CCOUNT, CUSTOMER.CZIP, CUSTOMER.CZIPLO
FROM ADTSLAB.CUSTOMER CUSTOMER
WHERE (CUSTOMER.CUSTNO=?)

When you click return data to Ms Excel click the parameters button and
select "Get the value from the following cell" and select the cell and
you might want to check the "Refresh automatically when cell value
changes"

-----
Bill

On Jun 7, 6:28 pm, "Saml" <none@no_such_isp.com> wrote:[color=blue]
> This may work: Configure an ODBC connection. Start Excel. Click menu
> Data/Import External Data/New Database Query using your new ODBC connection.
> Then write the SQL necessary to get your one record.
>
> Sam
>
> <I_am_f...@hotmail.com> wrote in message
>
> news:1181236117.328201.202220@p47g2000hsd.googlegroups.com...
>[color=green]
> > Hi,[/color]
>[color=green]
> > Is there a simple way of retreiving a single record from DB2 file with
> > Excel based on row/column value.[/color]
>[color=green]
> > Thanks.[/color][/color]

I am trying to incorperate GL# validation in a spread sheet (for the
users). The upload function will run a validation routine and I am
trying to figure out the best possible way to validate pre-uploaded
information. I was figuring on creating a routine in excel that
would process each row in the spread sheet and call a SQL procedure to
return a data set, the data set would hold one record if the GL# was
correct and no values if the GL# was invalid. If anyone has a
suggestion I will certainly welcome it. I dont know if i am clear on
the task at hand.

Thanks.








On Jun 8, 5:48 am, "Bill @MMSD" <wthomp...@madison.k12.wi.us> wrote:[color=blue]
> That does work, I use it all the time.
> I also make the use a parameter in the SQL and link it to a cell in
> excel and when that value changes it can automatically refresh the
> data.
>
> The way to do that is to click add criteria and slect your column and
> for your value type in [?]
>
> For example, this SQL uses IBM sample customer file included in
> library ADTSLAB.
> You could just copy and paste this by pressing SQL button.
>
> SELECT CUSTOMER.CUSTNO, CUSTOMER.CUSTNA, CUSTOMER.REPNO,
> CUSTOMER.CONTAC, CUSTOMER.CPHONE, CUSTOMER.CFAX, CUSTOMER.CADDR,
> CUSTOMER.CCITY, CUSTOMER.CCOUNT, CUSTOMER.CZIP, CUSTOMER.CZIPLO
> FROM ADTSLAB.CUSTOMER CUSTOMER
> WHERE (CUSTOMER.CUSTNO=?)
>
> When you click return data to Ms Excel click the parameters button and
> select "Get the value from the following cell" and select the cell and
> you might want to check the "Refresh automatically when cell value
> changes"
>
> -----
> Bill
>
> On Jun 7, 6:28 pm, "Saml" <none@no_such_isp.com> wrote:
>
>
>[color=green]
> > This may work: Configure an ODBC connection. Start Excel. Click menu
> > Data/Import External Data/New Database Query using your new ODBC connection.
> > Then write the SQL necessary to get your one record.[/color]
>[color=green]
> > Sam[/color]
>[color=green]
> > <I_am_f...@hotmail.com> wrote in message[/color]
>[color=green]
> >news:1181236117.328201.202220@p47g2000hsd.googlegroups.com...[/color]
>[color=green][color=darkred]
> > > Hi,[/color][/color]
>[color=green][color=darkred]
> > > Is there a simple way of retreiving a single record from DB2 file with
> > > Excel based on row/column value.[/color][/color]
>[color=green][color=darkred]
> > > Thanks.- Hide quoted text -[/color][/color]
>
> - Show quoted text -[/color]