Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Anyone got experience with NSQL?

Author  Topic 

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-08-08 : 11:01:37
HI all,

Our company has just purchased a solution called Clarity (a task / time management suite) and I've been selection (I am so lucky) to be the "Custom Reports Guy" for the project.

I've received documentation from Clarity and they use something called NSQL. Is that a sybase product? I've had a hard time finding much on the Web'

The website www.nsql.com is the following helpfull text...

"nsql.com nsql.com any information please contact info@nsql.com

testing by stephenCool?"

Anyone got any experience with this -- could point me to a good resource?

Here's some sample NSQL syntax....


SELECT
@select:dim:user_def:implied:TimeSheet:ts.PRID:ts_PRID@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRTIMEPERIODID:ts_PRTIMEPERIODID@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRRESOURCEID:ts_PRRESOURCEID@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRSTATUS:ts_PRSTATUS@,
@select:dim_prop:user_def:implied:TimeSheet:tsstatus.name:tsstatus@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRVERSION:ts_PRVERSION@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRSUBMITTEDBY:ts_PRSUBMITTEDBY@,
@select:dim_prop:user_def:implied:TimeSheet:submit.full_name:SubmittedBy@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRAPPROVEDBY:ts_PRAPPROVEDBY@,
@select:dim_prop:user_def:implied:TimeSheet:approv.full_name:ApprovedBy@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRISADJUSTMENT:ts_PRISADJUSTMENT@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRADJUSTEDID:ts_PRADJUSTEDID@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRMODBY:ts_PRMODBY@,
@select:dim_prop:user_def:implied:TimeSheet:ts.PRMODTIME:ts_PRMODTIME@,
@select:dim_prop:user_def:implied:TimeSheet:ts.POSTED_TIME:ts_POSTED_TIME@,
@select:dim_prop:user_def:implied:TimeSheet:tp.prid:tp_prid@,
@select:dim_prop:user_def:implied:TimeSheet:tp.prstart:tp_prstart@,
@select:dim_prop:user_def:implied:TimeSheet:tp.prfinish - 1:tp_prfinishLessOne@,
@select:dim_prop:user_def:implied:TimeSheet:entry.te_practsumsum / 3600:entry_te_practsumsum@,
@select:dim_prop:user_def:implied:TimeSheet:sres.id:sres_id@,
@select:dim_prop:user_def:implied:TimeSheet:sres.full_name:sres_full_name@,
@select:dim_prop:user_def:implied:TimeSheet:presdept.departcode:dept_departcode@,
@select:dim_prop:user_def:implied:TimeSheet:presdept.shortdesc:dept_shortdesc@,
@select:dim_prop:user_def:implied:TimeSheet:rman.id:rman_id@,
@select:dim_prop:user_def:implied:TimeSheet:rman.full_name:rman_full_name@
FROM
prtimesheet ts
INNER JOIN cmn_lookups_v tsstatus
ON ts.prstatus = tsstatus.lookup_enum
INNER JOIN prtimeperiod tp
ON ts.prtimeperiodid = tp.prid
INNER JOIN (SELECT
te.prtimesheetid te_prtimesheetid,
SUM(te.practsum) te_practsumsum
FROM
prtimeentry te
GROUP BY
prtimesheetid) entry
ON ts.prid = entry.te_prtimesheetid
INNER JOIN srm_resources sres
ON ts.prresourceid = sres.id
LEFT JOIN srm_resources rman
ON sres.manager_id = rman.user_id
LEFT JOIN (SELECT
pres.id pres_id,
dept.departcode departcode,
dept.shortdesc shortdesc
FROM
pac_mnt_resources pres
LEFT JOIN departments dept
ON pres.departcode = dept.departcode) presdept
ON sres.id = presdept.pres_id
LEFT JOIN srm_resources submit
ON ts.PRSUBMITTEDBY = submit.user_id
LEFT JOIN srm_resources approv





-------------
Charlie

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-08-08 : 11:12:29
We use the same product in our company. But my only experiene is in using the front end for data input.

Try replacing the "rubbish" at the start with good old "*". the rest of it looks like regular T-SQL.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-08-08 : 11:45:36
http://gems.ca.com/Gemsmarketing/CourseDesc.asp?crsCode=CLC362&clsType=B&ProdRel=7.5.3&Owner=NA-EDUC&LocalMenu=
...
Course Description
Reporting and Portlets in Clarity
...
You will learn how to convert SQL queries into NSQL queries, build a Portlet using NSQL, as well as review some NSQL constructs and see how they are used.
...




CODO ERGO SUM
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-08-08 : 11:54:31
Thanks MVJ,

I'm looking at that document (in manual form). The 6 hour course is on Thursday of next week and I imagine for every hour of it I will be thinking: "For this we paid £100?"

Might be wrong but I don't have high hopes.

-------------
Charlie
Go to Top of Page

schofieldski
Starting Member

1 Post

Posted - 2008-11-15 : 03:46:56
I train in NSQL - drop me a note.
Paul
Go to Top of Page

ElHmbreMasInteresDelMundo
Starting Member

1 Post

Posted - 2012-06-07 : 02:49:05
quote:
Originally posted by schofieldski

I train in NSQL - drop me a note.
Paul



I have a few questions about passing parameters to and from an NSQL query - also, can you create NSQL queries separately for each tab of a Portlet?
Thanks
Go to Top of Page

awadheshd
Starting Member

1 Post

Posted - 2014-09-02 : 07:00:39
quote:
Originally posted by schofieldski

I train in NSQL - drop me a note.
Paul



Hey Paul, You have Xls which convert SQL to NSQL directly please I am very new to NSQL and allocate on project without any traning! :(
I badly need it Please help
Go to Top of Page
   

- Advertisement -