MVSFORUMS.com

NorthernDancer · Posted: Fri Feb 26, 2016 11:17 am Post subject: SPUFI Update Table Columns

I want to use SPUFI if possible to plug some columns with test data. And I want to Concatenate like parts of 2 existing columns together. So the new data becomes easily recognized. Say for example 1st 5 bytes of ZIPCODE concatenated with 1st 10 bytes of CityName. Would I just use the Concatenate character (whatever that is) between them on the SET ?? So then maybe SET HUBID = ZIPCODE(1:5)|CityName(1:10) ??

kolusu · Posted: Fri Feb 26, 2016 12:11 pm Post subject:

NorthernDancer,

You can do it quite easily as long as the target and source columns have the same attributes. If you have different attributes then you need to convert the source column to match target column attributes.

Check this link for examples

http://www.mvsforums.com/helpboards/viewtopic.php?p=58823#58823
_________________
Kolusu
www.linkedin.com/in/kolusu

NorthernDancer · Posted: Mon Feb 29, 2016 3:49 pm Post subject:

Thank You Sir, this is it easily as you said..............

kolusu · Posted: Mon Feb 29, 2016 6:48 pm Post subject:

NorthernDancer,

Glad you got it working but I would suggest you code the sql's so that easy to read and understand. Something like this

NorthernDancer · Posted: Tue Mar 01, 2016 4:31 pm Post subject:

Yeh, I just slapped it together to test it and zap some test rows. I like your way a lot better and neater. I didn't actually know you could leave so many blanks on separate cards and it still parses together OK. Idea