DECLARE @tblName nvarchar(20)
DECLARE @dbName nvarchar(40)set @tblName='F3002'
set @dbName='jdedata812.dbo.F3002'select @tblName as tblName,SIMD=(SELECT SIMD FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=@tblname)
,SIPFX=(SELECT SIPFX FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=@tblname), a.name ,
DESC1=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP<>'CS') ,
DESC2=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP='CS') ,
--b.xtype,
b.name as type,b.length
from jdedata812.dbo.syscolumns a
inner join jdedata812.dbo.systypes b
on a.xtype=b.xusertype
inner join jdedata812.dbo.sysobjects c on
a.id=c.id AND c.xtype='U' AND c.name<>'dtproperties'
where a.ID=object_id(@dbName)
DECLARE @dbName nvarchar(40)set @tblName='F3002'
set @dbName='jdedata812.dbo.F3002'select @tblName as tblName,SIMD=(SELECT SIMD FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=@tblname)
,SIPFX=(SELECT SIPFX FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=@tblname), a.name ,
DESC1=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP<>'CS') ,
DESC2=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP='CS') ,
--b.xtype,
b.name as type,b.length
from jdedata812.dbo.syscolumns a
inner join jdedata812.dbo.systypes b
on a.xtype=b.xusertype
inner join jdedata812.dbo.sysobjects c on
a.id=c.id AND c.xtype='U' AND c.name<>'dtproperties'
where a.ID=object_id(@dbName)
tblName varchar2(20):='F3002' ;
dbName varchar2(40):='jdedata812.dbo.F3002';select &tblName as tblName,SIMD=(SELECT SIMD FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=&tblname)
,SIPFX=(SELECT SIPFX FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE 'F%' AND SIOBNM=&tblname), a.name ,
DESC1=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP <>'CS') ,
DESC2=(SELECT TOP 1 FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP='CS') ,
--b.xtype,
b.name as type,b.length
from jdedata812.dbo.syscolumns a
inner join jdedata812.dbo.systypes b
on a.xtype=b.xusertype
inner join jdedata812.dbo.sysobjects c on
a.id=c.id AND c.xtype='U' AND c.name <>'dtproperties'
where a.ID=object_id(&dbName)
tblName varchar2(20):='F3002' ;
dbName varchar2(40):='jdedata812.dbo.F3002'; select &tblName as tblName,SIMD=(SELECT SIMD FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE '||F||%' AND SIOBNM=&tblname)
,SIPFX=(SELECT SIPFX FROM JDEOL812.DBO.F9860 WHERE SIOBNM LIKE '||F||%' AND SIOBNM=&tblname), a.name ,
DESC1=(SELECT FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP <>'CS' and rownum=1) ,
DESC2=(SELECT FRDSCA FROM jdedd812.dbo.F9203 WHERE FRDTAI=SUBSTRING(a.NAME,3,LEN(a.NAME)) AND FRLNGP='CS' and rownum=1) ,
--b.xtype,
b.name as type,b.length
from jdedata812.dbo.syscolumns a
, jdedata812.dbo.systypes b ,jdedata812.dbo.sysobjects c
where a.xtype=b.xusertype
and
a.id=c.id AND c.xtype='U' AND c.name <>'dtproperties'
and a.ID=object_id(&dbName)