Data Management SQL script using a variable

Content

We have ~10 scripts for conversion from VB (FDM classic) that use a temp variable based on a target custom member.  In this case the second segment of the target entity is stored in a variable and appended to the location which is based on the source account.  In some scripts there are thousands of combinations so multi-dim maps aren't feasible.  How can we define a variable in the mapping script?

Version

21.08.93

Code Snippet

strSrcPlatform = varValues(16) 'get the entity
strSrcAcct = varValues(13) 'get the source account
strTarPlatform = """"   'set the initial platform to blank
strSrcC1 = varValues(19) 
strTarAcct = varValues(14)

If InstrRev(strSrcPlatform, ""_"") >0 Then ' check to make sure the entity has a platform at the end

     strTarPlatform = Mid(strSrcPlatform,InstrRev (strSrcPlatform, ""_"")) 'if the entity has a platform at the end, grab it and store this value

End If



Select Case strSrcAcct 'take the account and based on the value, choose which entity is the ICP

	Case ""04006000"",""04006323"", ""04006339"", ""04007000"",""04007323"" ,""04007339"",""05016000"",""05016323"" ,""05016339"" ,""05017000"",""05017339"" ,""07076000""  ,""07076323"" ,""07076339"" ,""07077000"" ,""07077323""  ,""07077339"" 
	strTarICP