Search results for query: *

Hello ... I'm not sure if I'm posting this question in the correct forum, if not, please let me know. I'm hoping someone has some experience with the DSQEC_LAST_RUN global variable. I read this variable controls the updating of the LAST_USED column in Q.OBJECT_DIRECTORY. Our installation has...

Hi everyone. I would like some advice on how to read in raw data where each record has multiple fields in which the delimiter used to start the string is different than the delimiter used to identify the end. The backwards apostrophe (`) is used to indicate the beginning of the value and a...

Thank you!

Hi Frederico ... Can I ask you a follow up question. I just learned that the business assigned a value of "0000". How would I change your query to include a value of 0000? Thanks again ... Kent

Thanks Frederico, that worked perfectly! Now I'll have to try and figure out what how that works ... I've never used these functions before. Thanks a bunch!

I’m not sure how best to describe what I’m looking for so apologies in advance if I’m not clear. I’m trying to come up with a solution to create as instream sequence number set as a source for comparison. We have a table where we store a four-digit number that has been assigned to a customer...

Sorry ... I pasted the wrong value from the SAS log ... it should have been: ED_200_PURGE_DATE=-10576

Hi sasbuddy ... thank you for the feedback. I added your suggestion to my options statement, but it didn't seem to work. Here is what I did: OPTIONS NOSOURCE YEARCUTOFF = 1920 ; From my input statement: @45 ED_200_PURGE_DATE YYMMDD6. From my put statement: @41 ED_200_PURGE_DATE...

Hi everyone ... I am having an issue with the century portion of a date. I am reading in a date value of YYMMDD using a YYMMDD6 informat. An example is 130113 for January 13, 2013. When I write the value out in my put statement with a format of YYMMDD10, I'm getting the value 1913-01-13...

Hi everyone ... I'm hoping you guys can offer some guidance. My update query doesn't seem to work. I'm using QMF to interact with DB2 v9 on z/OS. I typically stick to select statements so I'm a bit out of my element. Here is what I've got: UPDATE TABLE1 A INNER JOIN TABLE2...

Hi everyone ... Thank you for the valuable feedback. I completely agree, the data is in a less than desirable format and the requested output is no better. However, the data is being passed to me by one application and the customer has given me strict requirements on how they want the result...

Hello ... I hope someone can help me on this. I have a table that lists customers and the books they have purchased tne the language they purchased that book in. I have three requirements and what I thought was an easy task is turning out not to be so easy. Here is the way I originally...

I couldn't figure out what coalesce did.

Hi everyone ... Just an update, I found the following seems to work and uses the CASE statement: CASE WHEN B.USR_R_NM IS NULL THEN '*** USER ' || RTRIM(A.USER_ADD_ID) || ' DELETED ***' ELSE B.USR_R_NM...

Hello ... I'm looking for some advice on how to handle the following task. I’m trying to get a value to display if the original value is NULL. Here is my SQL: CASE (B.USR_R_NM) WHEN X'60'...

Hi Klaz ... just an update. I tried the following and it works: Y=PUT(DATEPART(ED_200_BASE1_EFF_DATE),YYMMDD10.); Z=PUT(TIMEPART(ED_200_BASE1_EFF_DATE),TIME16.6); IF HOUR(ED_200_BASE1_EFF_DATE) LT 10 THEN SUBSTR(Z,1,1) = '0'...

Hi Klaz ... I tried the following but am getting an error: 1 OPTIONS OBS=102 FIRSTOBS=1; 2 DATA R001; 3 INFILE INPUT1; 4 FILE SYSOUT...

Makes sense, thanks again Klaz! :-)

Hi Klaz ... thank you for the response! I will give this a try. Can you offer any insight as to why when using the YYMMDD10. format the data is displayed with all asterisks? Thank you again! KS

I’m having some problems writing out a timestamp field. The format that I was aiming for was YYYY-MM-DD-HH:MM:SS.ssssss. The informat used to read in the data was TODSTAMP4.. Here are some samples of my output using a PUT statement: NO FORMAT DATETIME23.6 TIME12...