WsSql user friendly GUI interface
Hi,
Is there any user-friendly interface to use with wssql? (for a non-developer type of user)
The default one, on port 8510 is a bit basic.
For example, as far as I could test, it returns results in a raw XML format (as opposed to the WsECL that shows a pretty nice table)
I understand that the feature is mainly meant to be used programmatically, but perhaps someone can recommend a way of working with it in a more interactive way with some external tool like the ones that exist for relational databases, that for example presents the results as a table, and allows to export the resultset as a csv, or other kind of flat-file.
Or any kind of GUI that allows accessing the end-point and retrieving the results in a graphical way.
Thank you!
Is there any user-friendly interface to use with wssql? (for a non-developer type of user)
The default one, on port 8510 is a bit basic.
For example, as far as I could test, it returns results in a raw XML format (as opposed to the WsECL that shows a pretty nice table)
I understand that the feature is mainly meant to be used programmatically, but perhaps someone can recommend a way of working with it in a more interactive way with some external tool like the ones that exist for relational databases, that for example presents the results as a table, and allows to export the resultset as a csv, or other kind of flat-file.
Or any kind of GUI that allows accessing the end-point and retrieving the results in a graphical way.
Thank you!
- rfernandez2007
- Posts: 25
- Joined: Mon Nov 29, 2021 2:40 pm
Hi, since the WsSQL jobs are processed as ECL, there should be a resulting workunit you can access via ECLWatch. The WsSQL result should report the Workunit ID which you can use to view the results via the ECLWatch tools. Thanks.
- rodrigo.pastrana
- Posts: 29
- Joined: Tue Jun 10, 2014 2:19 pm
Hi Rodrigo,
Nice workaround. I'll keep it in mind.
Thank you very much!!
Warm Regards
Nice workaround. I'll keep it in mind.
Thank you very much!!
Warm Regards
- rfernandez2007
- Posts: 25
- Joined: Mon Nov 29, 2021 2:40 pm
Hi, I'm glad we could help. Thanks for posting, and definitely let us know if you have any other question/concern. Rodrigo.
- rodrigo.pastrana
- Posts: 29
- Joined: Tue Jun 10, 2014 2:19 pm
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest