but It gives me same value 10 in almost all cases wether it is DATE or Integer type. How Can I get actual datatype of that value.

I am getting this error while compiling few files.
 

ERROR #5373: Class 'EnsLib.HL7.Message', used by 'TEST.Fw.CUnitTestBase:GetHL7FromString:ReturnType', does not exist

> ERROR #5030: An error occurred while compiling class 'TEST.Fw.CUnitTestBase'

ERROR #5373: Class 'EnsLib.HL7.Message', used by 'TEST.Fw.CUnitTestBase:GetHL7FromXData:ReturnType', does not exist

> ERROR #5030: An error occurred while compiling class 'TEST.Fw.CUnitTestBase'

How you are running the testcases. I tries to copy the Fw dir to my project but it is not working.

so you mean to say that sql query DATEDIFF() method is right to be used in code instead of ZDATETIME()

@John Murray 
thanks for sharing link. I tried the both 2 approach
1. Database query with DATEDIFF(s, '1970-01-01 00:00:00', BirthDate) => OUTPUT = -54777600

2. $ZDATETIME(BirthDate, -2) => OUTPUT = -54797400

where BirthDate = 46483

which is not same. So I am confused if the query result is wrong or 2 approach result.

mocking-framework]    Reload START (/Users/irisusr/mgr/Temp/6665534996923997/InterSystems-UnitTest-Mocking/)
[mocking-framework]    Reload FAILURE
ERROR! Resource path '/Users/irisusr/mgr/Temp/6665534996923997/InterSystems-UnitTest-Mocking/src/chs' not found

getting this error while running the same command
ERROR! ObjectScript error: <CLASS DOES NOT EXIST>%GetClass+5^%ZPM.PackageManager.Developer.Extension.SourceControl.Interface.1 *SourceControl.Git.Extension
  > ERROR #6315: Errors reporting importing XML subelement in file '/Users/irisusr/mgr/Temp/6665532401621932/InterSystems-UnitTest-Mocking/module.xml' at line '3' offset '42', skipping this item.

Hi @Guillaume Rongier 
I was also looking the same repository. Try to install it by using ZPM. But it was giving error below - 

ERROR! 'mocking-framework' not found in any repository.
any article how to setup this framework in my existing project on a local iris server.

It is not what i want. I am writing unit test  cases and Also I have tested APIs from Postman but for Unit testing we need to write Unit testcases.

How can i check in resultset if there is any record present in the resultset.

Thanks it worked.

I don't see dispatch classes in vs code. Also, Sharing a sample code for the same would be more helpful.

catch block looks something like this.

}catch (err){

do ..%SetStatusCode(500)

set res.stateCode = 500

set res.msg = "Server Internal Error"

set res.ErroMsg = err.%Message

return err

}

So In this case, If i wanna know the value return from this object is of which data type. How can I achieve that?

I didn't get any standard methods in this library. If any other you can suggest?

What does 

this mean?

yes i am using iris 2023.1

i am getting error on this <method does not exist> on GetColumnType

how it is used?
resultSet.GetCoumnType(i)
 

I am running iris 2023.1, Also I have created an irisusr but i am not aware if that irisusr have access to my /User/abc/workspace 
I am currently working on OS - Mac
If you can help me get access to the workspace to irisusr.

Adding to above question along with column name, I want to get type of data value it is storing in DB. Example - column Name - String, Age - Integer etc.
How can I get this as well.

I am following standard installation steps. Also, it is solely for my own practice and understanding. 
I had created a group - irisusr and user - irisusr before installation as a prerequisite

How about zpm install "git-source-control" 
what exactly it do. Also, can I manage to run git commit and other statements as we do from terminal in vscode or it is specific to UI only.

I tried this but it didn't work. Also here is how I am using args to set value inside.
do args.%Push(requestBody.firstname) 

do args.%Push(requestBody.surname)

then I did the same thing. - 

set resultSet = ##class(%SQL.Statement).%ExecDirect( , sql_whereClause, args...)

Does that mean I should run IRIS system in docker instead of installing it on my host machine?