Import CFD File layout

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kumar_j12
Participant
Posts: 26
Joined: Wed Oct 03, 2007 8:10 am

Import CFD File layout

Post by kumar_j12 »

Hi All,

I am facing an error when i try to import the table definition using sequential stage which contains the CFD(Cobol) File layout

I used sequential stage because the data is Ascii format

Error message is
'*' Unrecognized syntax

It is working in my friends machine.Do i need to change any formats in the notepad or something else

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

What column is that "*" in? Cobol is picky about indenting. Col 7 for comment, 8-11 and 12 to 79.
kumar_j12
Participant
Posts: 26
Joined: Wed Oct 03, 2007 8:10 am

Post by kumar_j12 »

Image

Line number 12.
if i delete manually ,it pointed to next line *.

It is working in my friend machine
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

What is the start position you provided? It must be 8.

Surprising that it left the top 5 lines. Did you give the header lines?
kumar_j12
Participant
Posts: 26
Joined: Wed Oct 03, 2007 8:10 am

Post by kumar_j12 »

The start point is from line 1
Sainath.Srinivasan wrote:What is the start position you provided? It must be 8.

Surprising that it left the top 5 lines. Did you give the header lines?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Not line 8 but column 8, the "*" means a comment in column 7 and thus your error.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Arnd is talking about columns - why are you talking about lines? His point is that you must correctly identify the column in which the "A margin" - where the 01 level items occur - is. Based on your example, I believe that this should be 2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_j12
Participant
Posts: 26
Joined: Wed Oct 03, 2007 8:10 am

Post by kumar_j12 »

I am unable to understand.

My question is why i am getting this error in my machine,as it worked in other machine
Is there any wrong with my machine(changing any parameter in control panel) to get rid of * error
ray.wurlod wrote:Arnd is talking about columns - why are you talking about lines? His point is that you must correctly identify the column in which the "A margin" - where the 01 level items occur - is. Based on your ...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You set it in the import dialog itself.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply