Hello,

I'm using package RpgSQL. Is there a better way to create a multi-line
query/character string? I'm looking for less to type and readability.

This is not very readable for large queries:
s <-  'create table r.BOD("id" int primary key,"name" varchar(12))'

I write a lot of code, so I'm looking to type less than this, but it is
more readable from and SQL standpoint:
s <- gsub("\n", "", 'create table r.BOD(
"id" int primary key
,"name" varchar(12))
')

How it is used:
dbSendUpdate(con, s)

Regards,

Ben

	[[alternative HTML version deleted]]