Re: ? about SQL Long table names and funky member names

How are you migrating this data?

Let's say your SQL Server has this table
CREATE TABLE ROB.INGODDADAVIDABABY (
WHENIWASTHERE TIMESTAMP,
IWANTEDTOBEHERE CHAR (30 ),
BUTNOWTHATIMHERE CHAR (30 ),
IWANTTOBETHERE INT
)

Then you could suck that into DB2 with
create table rob.alasbabylon for system name my10char
as (
select * from gdisys.rob.ingoddadavidababy) with data
Table ALASBABYLON created in ROB.

Note:
One: See the "for system name"?
Two: Three part naming. You'll have to be pretty good to set up the
relational database connection to SQL Server to do this but it is quite
doable. See also ARDGATE (google that).
Three: See the member name below.

DSPFD FILE(ROB/MY10CHAR)
DSPFD Command Input
File . . . . . . . . . . . . . . . . . . . : FILE MY10CHAR
Library . . . . . . . . . . . . . . . . . : ROB
Member List

Member Size
MY10CHAR 12288

This rename crap is for ancient versions of the OS which did not support
"for system name" or RCDFMT

FOR SYSTEM NAME system-object-identifier
Identifies the system-object-identifier of the table.
system-object-identifier must not be the same as a table, view, alias, or
index that already exists at the current server. The
system-object-identifier must be an unqualified system identifier.
When system-object-identifier is specified, table-name must not be a
valid system object name.
For example you cannot do the following:
CREATE TABLE ROB.BUCK FOR SYSTEM NAME WHEAT (MYCHAR CHAR (30))
because wheat and buck are both valid 10 character or less system names.

RCDFMT
Indicates the record format name of the table.
RCDFMT format-name
An unqualified name that designates the IBM i record format name of
the table. A format-name is a system identifier.
If a record format name is not specified, the format-name is the same
as the system-object-name of the table.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Vicki Wilson <VWilson@xxxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 03/30/2015 06:02 PM
Subject: ? about SQL Long table names and funky member names
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Hi all,

I'm migrating some SQL Server tables to DB2. I'd like to keep the long
table name so I'm using RENAME to get a palatable system name rather than
the funky generated name.

I noticed that I still get a funky member name xxxxx00001. How do I
rename this? Can I do it in the same script I use to generate the table?
Does it matter???

Vicki


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.