Trying to find definition for a return vaue of -6

I am receiving a return value of -6 from the attached SQL Server 2016 stored procedure.  Is there a list of return values and what they mean.  I haven't found any.
Juan VelasquezAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
which attached SP?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Juan VelasquezAuthor Commented:
Here is the attached file.  Sorry about that.
0
Juan VelasquezAuthor Commented:
It looks like I found the problem.
The -6 return value was generated in the following section of the stored procedure.  It was caused by a data issue where the value for itemclass and itemsect was '??'.  The convert function or concatenation process didn't know what to do with a value of ??
However a list of return values and their meanings would be helpful

INSERT INTO tbl_convert ( CLASS, [SECTION], ITEM, [CLASS/SECTION], DESCRIPTION, [PRIMARY UOM] )
		SELECT dbo.vw_LIS005MAST_Item.ItemClass, dbo.vw_LIS005MAST_Item.ItemSect, 
		LTrim(RTrim(dbo.vw_LIS005MAST_Item.Itm)) AS Item, 
		CONVERT(Varchar(10),dbo.vw_lis005mast_item.[itemclass]) + CONVERT(VARCHAR(10),dbo.vw_lis005mast_item.[itemsect]) AS Class, 
		dbo.vw_LIS005MAST_Item.IiDesc, LTrim(RTrim(dbo.vw_LIS005MAST_Item_UOM.[UOM])) AS PUOM
		FROM dbo.vw_LIS005MAST_Item 
		INNER JOIN dbo.vw_LIS005MAST_Item_UOM ON dbo.vw_LIS005MAST_Item.Server = dbo.vw_LIS005MAST_Item_UOM.[Server]
			AND dbo.vw_LIS005MAST_Item.Itm = dbo.vw_LIS005MAST_Item_UOM.ImItm WHERE dbo.vw_LIS005MAST_Item.ItemClass NOT like 'Kit%'
		ORDER BY dbo.vw_LIS005MAST_Item.ItemClass, dbo.vw_LIS005MAST_Item.ItemSect, LTrim(RTrim(dbo.vw_LIS005MAST_Item.[Itm]));

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Éric MoreauSenior .Net ConsultantCommented:
what does your SP returns? Do you have a "RETURN @variable name" at the end of your SP?
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
chtullu135 - I really recommend taking a step back, gathering your thoughts, and then re-ask your question with enough supporting details for experts to provide an answer.  

Keep in mind that experts here cannot connect to your data source(s) and run queries, and since we don't work at your company have no idea about company-specific terms.
0
Juan VelasquezAuthor Commented:
I was just looking for a list of return values and what they mean. That's all I was looking for.  I don't need any help in finding the problem in the code.  I was looking online and could not find such a list.  For example, what does a return value of -6 mean. I do not need any assistance in troubleshooting the actual problem.  I only supplied the code to provide context. Come to think of it, I think I saw such a list in one of my books at home. I will close this question.
0
Éric MoreauSenior .Net ConsultantCommented:
I suspect that you are returning this value, this is why I asked the questions here above!
0
Juan VelasquezAuthor Commented:
Not a problem Eric.  Thank you for your help.  The procedure ran without throwing an error.  I then ran each of the sql statements until I reached the one that was causing the problem which was the one above.
0
Juan VelasquezAuthor Commented:
Thanks for your help, it helped clarify the issue which was caused by a datatype conversion error
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Stored Proc

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.