Can Data set be accessed from any external editor
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
Can Data set be accessed from any external editor
Hi
Have a requirement to access Data set from Java editor.
Could some one provide pointers on how this can be achived?
Regards,
Sudeep
Have a requirement to access Data set from Java editor.
Could some one provide pointers on how this can be achived?
Regards,
Sudeep
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
what kind of access?
if access means reading date then yes only if your editor is smart enough to decode Datastage's internal format. And I don't know any such editor.
If you want to get statistics for datasets then you might be able to do that using datastage functions/executables. But I never used that.
Its documented and also I prefer to use filesets if the intermediate data is needed by any other external program.
if access means reading date then yes only if your editor is smart enough to decode Datastage's internal format. And I don't know any such editor.
If you want to get statistics for datasets then you might be able to do that using datastage functions/executables. But I never used that.
Its documented and also I prefer to use filesets if the intermediate data is needed by any other external program.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
Basically there are orchadmin utilities by which I can read a dataset from command line or dump it into a file (may be a CSV or something).
I just wanted to know if there's any other option by virtue of which I dont need to dump data into another file and from the command prompt or STDOUT itself I can read the formatted data properly.
P.S. I also need first line column name which is a Property exhibited only by a Sequential file stage.
I just wanted to know if there's any other option by virtue of which I dont need to dump data into another file and from the command prompt or STDOUT itself I can read the formatted data properly.
P.S. I also need first line column name which is a Property exhibited only by a Sequential file stage.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
Exactly....But the problem is it wont preserve the formatting of the data and I also need the first line as column name (there are some other requirements too)...Seems these can only be achieved only when I write from dataset to a sequential file..Which basically I cant do at this stage of the game!! :D
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A Data Set consists of multiple physical files. On that basis at the very least the answer is "no".
There are no columns, so there are no column headings. The storage schema is in the control file, not in the data files. Therefore the answer is still "no".
Data are in binary format. For example, an int32 occupies precisely four bytes. While some editors can "read" that, the question really is "can you?". Therefore I'm staying with the original "no" answer.
There are no columns, so there are no column headings. The storage schema is in the control file, not in the data files. Therefore the answer is still "no".
Data are in binary format. For example, an int32 occupies precisely four bytes. While some editors can "read" that, the question really is "can you?". Therefore I'm staying with the original "no" answer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: