Hi All,   Is there any way to get MA campaign start and end time including history ?   Best Regards. ... View more

Hi ,   My source table is in SAS and need to update the target table in DB2 . I am using the below code .however it is taking too long to execute if the source table has many rows . any suggestions on how to improve the performance. My target table can not be dropped or rows can not be deleted  due to constraints defined . please suggest for any other options. proc sql; update DB2.ACCOUNT set AREA = (select  AREA from updrecords where Account_key = "&account_key"),   COY = (select  COY from updrecords where Account_key = "&account_key"), BRANCH = (select  BRANCH from updrecords where Account_key = "&account_key"),     Please let me know if any further details required ... View more

Hi All,   Has anyone working on a short term solution to get away with Flash while we work on upgrade in parallel . one of the activity we are looking by installing a browser in Citrix environment with Flash plugin and no further patches/updates to the browser. Its kind of freezing/locking the browser. we are still testing out this approach.   Looking forward to hear if there are any other solutions considered and working from your side . i am sure most of us are in same situation.   Thanks in Advance.     ... View more

Hi,    We have the below campaign . As you could see we currently doesn't have any user/Group has Approve option.   We are not able to add or modify user/group to have Approve permission. With this we are not able to approve the campaign to mark for deployment.   Any suggestions ?     Approve Issue ... View more

Hi ,   I am reading a missing value dot(.) for one of the variable(Charecter) in csv file.  SAS is converting it as blank ('') in the output dataset.   How can i preserve dot(.) in the output .   Below are the details.   csv file :   12345|2-K|Mr.|David|WHITE|.|Y|09/03/2018|.|Australia/Sydney   Program  data work.W5RD4PZ5 ; infile "/sas/saswork/nag/CONTACTS_20200313_01.csv" lrecl = 1024 delimiter = '|' dsd missover firstobs = 1; attrib ID length = $30 format = $30. informat = $30.; attrib CONTACTREF length = $20 format = $20. informat = $20.; attrib TITLE1 length = $20 format = $20. informat = $20.; attrib GIVENNAME length = $100 format = $100. informat = $100.; attrib FAMILYNAME length = $100 format = $100. informat = $100.; attrib COMPANYNAME length = $200 format = $200. informat = $200.; attrib ISEXTERNALLYMAINTAINED length = $1 format = $1. informat = $1.; attrib LASTMODIFIED length = $20 format = $20. informat = $20.; attrib MIDDLENAME length = $100 format = $100. informat = $100.; attrib TIMEZONE1 length = $40 format = $40. informat = $40.; input ID CONTACTREF TITLE1 GIVENNAME FAMILYNAME COMPANYNAME ISEXTERNALLYMAINTAINED LASTMODIFIED MIDDLENAME TIMEZONE1; run;   Output :   From the above file , Variables Companyname and Middlename are having values as dot(.) but in the ouput dataset it is showing as blank(''). How can we retain (.) in the output .   Thanks in Advance.   ... View more

Hi All,   I would like to know only THE active treatments(currently assigned) assigned to any particular decision treatment campaign . Is it possible through CDM  data base ?   I am using the below code but it gives all the treatment codes (Current + History).   SELECT      DISTINCT TREATMENT_CD          FROM CI_PACKAGE_X_TREATMENT CPXT     INNER JOIN  CI_CELL_PACKAGE CP ON     CPXT.CONTRIBUTING_CELL_PACKAGE_SK = CP.CELL_PACKAGE_SK         INNER JOIN  CI_TREATMENT CIT       ON CPXT.TREATMENT_SK=CIT.TREATMENT_SK       INNER JOIN  CI_TREATMENT_EXT CITE       ON CIT.TREATMENT_SK = CITE.TREATMENT_SK WHERE CP.CAMPAIGN_CD='CAMP506094'   Thanks in Advance.     ... View more

Hi DI Experts ,   Field length is restricted to 200 char when  I am using tranwrd function to replace Tab and carriage return in the expression column in the field mappings in the table loader transformation. i have mentioned 1500 as length but still it is only limiting to 200   Source is Teradata and Target is Oracle . Below is the expression used.   tranwrd(tranwrd(OFFER_REASON, '09'x,''),'0d0a'x,'')   Any work around to get away with it ?   Thanks in Advance ... View more