1 - 16 of 16
PREVIOUS 1 NEXT
Control Cards for NDM from Server to JCL
How can we concatenate the file name to read from Server in NDM &SDD='&INDD1 || _ || &DATE || . || &ATTB' -
How can we concatenate the file name to read from Server in NDM &SDD='&INDD1 || _ || &DATE || . || &ATTB' -
5 pts.
How do I prevent from losing the first position of a non "0" field?
How do I prevent from losing the 1st position of non "0" field, using this logic: WHERE concat(TRN@DS, concat(substring(concat('00',TRNYDS),2,2), concat(substring(concat('00',TRNMDS),2,2), substring(concat('00',TRNDDS),2,2)))) between
How do I prevent from losing the 1st position of non "0" field, using this logic: WHERE concat(TRN@DS, concat(substring(concat('00',TRNYDS),2,2), concat(substring(concat('00',TRNMDS),2,2), substring(concat('00',TRNDDS),2,2)))) between
Concatenation
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
Dummying a dataset with a concatenated list of datasets
I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to...
I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to...
Creating a list in one Excel cell by referencing several other cells
Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...
Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...
How to convert VBA decimal DataTypes
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 ...
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 ...
concatenating rows of a column in oracle 9i sql
how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??
how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??
Concatenating two note fields into one, but need them to be on their own line
sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?
sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?
validation
i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i
i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i
Concatenate
I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name...
I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name...
Trim Trailling Spaces
How do I trim trailling spaces when I concatinate 2 character fields. Like when you concat names there is a big space between the 2 names.
How do I trim trailling spaces when I concatinate 2 character fields. Like when you concat names there is a big space between the 2 names.
Concatenate Two Fields t-sql
I need to concatenate two fields one varchar(50) and the other varchar(12) The result I need is to see the full 50 characters of the first field even though all 50 may not be filled. Thanks
I need to concatenate two fields one varchar(50) and the other varchar(12) The result I need is to see the full 50 characters of the first field even though all 50 may not be filled. Thanks
Sample of how to concatenate files to ftp to server
I need to be able to combine three files into one then ftp them to a remote server. Does anyone have an example?
I need to be able to combine three files into one then ftp them to a remote server. Does anyone have an example?
storing multiple fields iin jsp into a single column in th table
i have one text filed and a select field.I have to concatenate both of them and store into a single column in the table. how do i achieve this??
i have one text filed and a select field.I have to concatenate both of them and store into a single column in the table. how do i achieve this??
concatenate more than 2 fields together into one field in SQL
say I have 3 columns, 1st name, midlle name and last name, how do I merge the 3 columns into one column yet separate the content with commas
say I have 3 columns, 1st name, midlle name and last name, how do I merge the 3 columns into one column yet separate the content with commas
rpg sql concat
Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...
Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...
1 - 16 of 16
PREVIOUS 1 NEXT
