Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator query question on select top n rows - newbie
Go
New
Search
Notify
Tools
Reply
  
Data Migrator query question on select top n rows - newbie
 Login/Join
 
Gold member
posted
I am trying to select the top 5000 rows and get the following: Token 5000 was not valid

What are the valid tokens and where do I find them. Is my query statement correct:

select TOP 5000 BETRM, BEACYR FROM Myfile Where BEACYR = 2011



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Does the source DB support TOP ?

What is it?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6053 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
It is AS400 and I got it to work. I was initially trying the top n rows when I added the fetch n rows only. I didn't clear out the "top n" so it was still erroring out.

This message has been edited. Last edited by: Brenda Wilkerson,



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
The reason I was trying to limit my query was the when I first ran and opened my txt file it showed: 2,726,677 of 2,726,677 records but there wasn't any data or headers. I checked write all columns and headers so I shoud have had headers and data. I tried to open it excel and it is blank. Any help?



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
I'm not a data migrator person, but post the code and I'll take a look.

Also others will have the change to check it as well.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6053 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Figured it out too. Found a union that didn't have columns mapped....arghhh... took this class over a year ago and just now getting to use it. and there are no user type manuals and the product help isn't that great.

Thx

This message has been edited. Last edited by: Brenda Wilkerson,



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Use the code tags, the </> button


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6053 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Glad you spotted the problem.

Alls good now ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6053 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator query question on select top n rows - newbie

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.