|
|
Posted by cognosqueen on 09/29/30 11:55
Roy - thanks so much!!! You are right about the JE Edwards column names!! I
do not enjoy them at all. Regarding the data type - the client already had
it set up - I just have to live with it!! I'll try this and see if it works!
Roy Harvey wrote:
>Aren't those JD Edwards column names a drag? I'm surprised you need
>UNICODE (nchar and nvarchar instead of char and varchar), I did not
>realize that JDE could handle anything beyond EBCDIC or ASCII.
>
>A VIEW is just a SELECT statement inside. The example has an INSERT
>statement. A VIEW can NOT have an INSERT statement.
>
>CREATE VIEW does not allow for specifying the data types in the VIEW
>column list. It is not part of the syntax.
>
>When I need to control the data type this way I use CONVERT, though
>CASE can do the same thing:
>
>CREATE VIEW F0005New
>AS
>SELECT CONVERT(nhcar(3), rtrim(F0005.DRKY)) as DRKY,
> CONVERT(nchar(30), F0005.DRDL01) as DRDL01
> FROM F0005
> WHERE DRSY = '41'
> AND DRRT = 'S1'
>
>Roy Harvey
>Beacon Falls, CT
>
>>I need to create a view of a sql table, but change the data types. I know
>>the syntax below is not correct, and can't figure out if it is wrong or if
>[quoted text clipped - 7 lines]
>>
>>Thanks!!
Navigation:
[Reply to this message]
|