Column Names Returned from a View
Posted in 1998
Experts, I've come across a problem that I'm hoping someone can help me with. First, the particulars: HW: Sun UE4000 OS: Solaris 2.5.1 DB: ODS 7.23.UC4 I've created a view with the following syntax: BEGIN WORK; CREATE VIEW "owner".name ( C1,C2,C3 . . . . CN ) AS SELECT '000001', SP_X('arg1','arg2','arg3','arg4'),=20 SP_X('arg1','arg2','arg3','arg4'), SP_X('arg1','arg2','arg3','arg4'), ., ., ., SP_X('arg1','arg2','arg3','arg4') FROM SysTables WHERE TabId =3D 99; COMMIT WORK; SP_X is a stored procedure that returns an integer value. When I select from the view I get the single row returned with the proper column values that I would have expected. However, I noticed while doing a "select * from view" that=20 the 33rd column identifier is always mangled. Further, if I select just this column the column name will also be re- turned with the first four characters being something other than what they should be. Repeatedly selecting this column=20 shows that the first four characters are always different.=20 If I eliminate one or more of the columns that precede the 33rd column from the view the 33rd column of this "new" view is still coming back wrong. If I "OUTPUT TO" the select statement, the=20 mangled column name appears in the output file. I've got several similar views in production but I have never=20 seen this behavior before. Has anyone run across a similar problem? TIA Larry Kemmerling AT&T Wireless Services Aviation Communications Division