Demonstrate DTW_TB_GETV and DTW_TB_ROW Functions

Return to the Net.Data Examples

This function demonstrates the new DTW_TB_rGETV function. It uses a single SQL statement to retrieve a set of data which is then displayed via the DTW_TB_rGETV function to produce three separate reports from the same set of data. It is based on IBM's sample macro at: IBM's Net.Data Website

Customers in Chicago:

Name Phone Fax City Zip Code
James Adams (201) 732-1023 (201) 732-1210 Chicago 60601
Aaron Smith (773) 533-7238 (773) 533-7230 Chicago 60612
Abbit Mendlesen (708) 499-3161 (708) 499-3160 Chicago 60615

Customers in Zip Code 10031:

Name Phone Fax City Zip Code
Alan Rogers (212) 755-6304 (212) 755-6301 New York 10031
Ricardo Rogers (212) 283-3940 (212) 283-3942 New York 10031

Customers in Area Code 212:

Name Phone Fax City Zip Code
Alan Rogers (212) 755-6304 (212) 755-6301 New York 10031
Ricardo Rogers (212) 283-3940 (212) 283-3942 New York 10031