I need to create a data item that have values not related to any of my other data items or queries? Basically the value that I want is 0 up to 36 that is shown only on 1 column .It will look like this when I query it....
0
1
2
3
4
5
6
7
8
9
10
...
...
..
...
36
Please help me with the syntax or how I can accomplish this.
If it's truly unrelated (i.e. you can't use running-count), you can...
...add a table with what you need to your database and package, or
...create a 36-part union in RS, each of which selects a static value from your database's pseudotable (e.g. DUAL in Oracle), or
...use running-count in a query from an unrelated table for which you can formulate a filter which will guarantee 36 rows returned.
Bottom line is it has to come from the db, either all at once or in pieces. If anyone knows how to do it from thin air please correct me, it would be very useful to know!