Column Headings help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Column Headings help

Column Headings help

Rate Topic

Display Mode

Topic Options

Author

Message

verian.thomas

Posted Monday, December 10, 2012 6:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 10, 2012 8:53 AM
Points: 2, Visits: 2

Apologies if I am in the wrong part of the forum, I'm new, and newbies seemed a good place to start.

We write a lot of quick one off AS400 queries (or green screen as everybody around here calls them) to check table data and the column headings are always the field description rather than the field name. So instead of 'Iprod' for example, which is useful, we get 'Itm Num', which is fine, but some of the descriptions are meaningless (I'm not an admin so can't change these). Is there a way, other than 'Specify Report Column Formatting' which seems to require manual entry every time for new queries, to have queries default to Field names rather than descriptions?

Many thanks in advance

Post #1394572

GSquared

Posted Monday, December 10, 2012 6:53 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

Just to be clear: Are you using an AS400 to connect to a Microsoft SQL Server database? Or are you using some database product native to the AS400?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1394589

verian.thomas

Posted Monday, December 10, 2012 6:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 10, 2012 8:53 AM
Points: 2, Visits: 2

Apologies again, I am quite possibly in the wrong place, this would be directly on the AS400, so native.

Post #1394590

GSquared

Posted Tuesday, December 11, 2012 6:15 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

Ah. This is pretty much a Microsoft SQL Server site. Someone might happen along who could help, but it's not a high probability. You're probably better off on an AS400 support site. Unfortunately, since I don't know AS400, I can't recommend one, so you're probably stuck with Bing/Google/whatever and a bit of research, to find one.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1395080

« Prev Topic | Next Topic »

Permissions