Table Definition, Format tab
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Table Definition, Format tab
In Table Definitions, on the Format tab, there is a tick-box "First line is column names". What earthly use is this? I know what it means, but how do I get DataStage to actually use the setting in Table Definitions in a job? Loading the columns into a Seq File stage doesn't also load this setting, and dragging the Table Definition onto a link doesn't copy this setting either, so it appears to be a half-implemented feature. Am I missing something?
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
On the Format Tab, there is a load button. This is what you would use to actually load the Format of the columns that are being defined. This would be "First Line is Column Names", your quote characters, delimeters etc.
Hope that explains it,
Hope that explains it,
Precious
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
D'oh! Why did I never notice that button?Precious wrote:On the Format Tab, there is a load button.
It seems a bit unnecessary to have to do both steps separately. I can see the advantage of being able to do them separately, but having to is annoying.
I'm still rather surprised that dragging the Table Definition onto the link doesn't load this data - both sets of data (Properties & Columns) are attributes of the link, after all. I suppose the link only has one set of columns, but can have two different sets of properties.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
First line column names advices Datastage that incoming sequential file has first row as column heading thus it will not be written in the target.
Ex: Ur sequential file as the follwing contents
Empno, sal
1,100
2, 200
3,300
In format tab if u check first line is column names the first row(empnno, sal) will not be processed.
Ex: Ur sequential file as the follwing contents
Empno, sal
1,100
2, 200
3,300
In format tab if u check first line is column names the first row(empnno, sal) will not be processed.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Yes I know, and we use sequential files a lot. I would like to streamline the process of configuring them, since relying on the developer to manually apply the sequential file properties (specifically the "First line is column names" flag, and the "Default NULL string" value) is error-prone. I have a Perl script that scans the XML export for this kind of missing property, but it's a less-than-ideal solution.ray.wurlod wrote:The Format tab is only for Sequential Files. There is an annotation on the page to this effect.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant