Re: A few question if you have time.

[Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM>]

  We use DB2 UDB on AIX RS/6000

  ANSWERS
 1. NOPE , use SQR code to do it
 2. NOPE cant use the buffer size flag
 3. Not Sure good Question.




-----Original Message-----
From: Alan Ljungberg [mailto:Alan.Ljungberg@CNPL.ENBRIDGE.COM]
Sent: Tuesday, February 05, 2002 11:22 AM
To: SQR-USERS@list.iex.net
Subject: A few question if you have time.


I'm having to run some SQRs on both DB2 and Oracle databases.  Oracle I am
comfortable with, but DB2 has some differences that are causing me
difficulty.  Here are my three questions.

1. As I understand it the -TB flag added to a SQR select on a DB2 database
will PREVENT the removal of trailing blanks.  Does anyone know of a flag
that will force the select to TRIM trailing blanks?

2. Will the -Bnn buffer size override flag work on a DB2 database?
Documentation seems to indicate this is an Oracle and Sybase flag.

3. When selecting data from and Oracle data base one can control the
default date display but doing an:

 BEGIN-SQL
  ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD'
 END-SQL

Is there any way to accomplish the same when selecting data on a DB2
platform ?

This is my first post here hope you can help me.
Thanks in advance.

-Alan Ljungberg