Determining which concatenated dataset is being processed by a COBOL program
I’d like to determine which dataset in a group of concatenated datasets is currently being processed. I have multiple datasets going through an edit process (COBOL) on a mainframe and when I find an error I’d like to list the DSN the record is in.
Answer Question
| July 21, 2011 4:22 PM
COBOL, Concatenate, Datasets, DSN, Mainframe
I’d like to determine which dataset in a group of concatenated datasets is currently being processed. I have multiple datasets going through an edit process (COBOL) on a mainframe and when I find an error I’d like to list the DSN the record is in.
Answer Question
| July 21, 2011 4:22 PM
COBOL, Concatenate, Datasets, DSN, Mainframe
SQL concatenate results
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
How can I concatenate files for transfer from the iseries
I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a [...]
Answer Question
| February 28, 2011 3:12 PM
AS/400 Query, Concatenate, i5, i5 Commands
I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a [...]
Answer Question
| February 28, 2011 3:12 PM
AS/400 Query, Concatenate, i5, i5 Commands
How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
Times spanning midnight in RPG/400 concatenation
I have successfully converted time field to date/time. Now I need to find the total minutes between one field and another but cannot get it to show me any value. I am using DateDiff (‘n’,{@startdatetune}, {@startdatetime}) where n indicates minutes. I should be able to use any field where I have concatenated the date and [...]
Answer Question
| December 30, 2010 2:02 PM
Concatenate, RPG/400, RPG/400 Field Concatenation
I have successfully converted time field to date/time. Now I need to find the total minutes between one field and another but cannot get it to show me any value. I am using DateDiff (‘n’,{@startdatetune}, {@startdatetime}) where n indicates minutes. I should be able to use any field where I have concatenated the date and [...]
Answer Question
| December 30, 2010 2:02 PM
Concatenate, RPG/400, RPG/400 Field Concatenation
Total Balance for Concatenated Unique ID in Access and Excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]
Answer Question
| October 29, 2010 2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]
Answer Question
| October 29, 2010 2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel
Concatenate many *CHAR variables.
Is it possible to Concatenate many *CHAR variable in one same type variable. I’ve created a CL who will read records from one file and concatenate them in one varaible which i will use after in my CL. But after exiting the loop i got a varaible with the last record value so the concatenation [...]
Answer Question
| October 7, 2010 4:30 PM
AS/400, CL variables, Concatenate, Variables
Is it possible to Concatenate many *CHAR variable in one same type variable. I’ve created a CL who will read records from one file and concatenate them in one varaible which i will use after in my CL. But after exiting the loop i got a varaible with the last record value so the concatenation [...]
Answer Question
| October 7, 2010 4:30 PM
AS/400, CL variables, Concatenate, Variables
SYNON built in function *CONCAT
I need to combine several fields into one text field and thinking about using *CONCAT for that. However it seems that *CONCAT can only merge two fields at a time. If so it would mean a lot of code if I have ten fields to merge. Am I understanding this correctly? Thanks for any help! [...]
Answer Question
| August 9, 2011 3:07 PM
AS/400, AS/400 Synon, Concatenate, Synon 2E
I need to combine several fields into one text field and thinking about using *CONCAT for that. However it seems that *CONCAT can only merge two fields at a time. If so it would mean a lot of code if I have ten fields to merge. Am I understanding this correctly? Thanks for any help! [...]
Answer Question
| August 9, 2011 3:07 PM
AS/400, AS/400 Synon, Concatenate, Synon 2E
Inserting Hex values into Excel
Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex “4F”. The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. [...]
Answer Question
| November 10, 2010 9:51 PM
Concatenate, excel, Excel formulas, Excel functions, Hexadecimal values
Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex “4F”. The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. [...]
Answer Question
| November 10, 2010 9:51 PM
Concatenate, excel, Excel formulas, Excel functions, Hexadecimal values
MySQLi and PHP problem with code
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]
Answer Question
| April 9, 2010 10:02 PM
Concatenate, Database, MySQL, PHP, table
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]
Answer Question
| April 9, 2010 10:02 PM
Concatenate, Database, MySQL, PHP, table
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’ –
Answer Question
| August 31, 2009 2:56 PM
Concatenate, Network Data Mover
How can we concatenate the file name to read from Server in NDM &SDD=’&INDD1 || _ || &DATE || . || &ATTB’ –
Answer Question
| August 31, 2009 2:56 PM
Concatenate, Network Data Mover
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
Answer Question
| June 11, 2009 3:51 PM
Concatenate
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
Answer Question
| June 11, 2009 3:51 PM
Concatenate
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?
Answer Question
| June 10, 2009 6:55 PM
Concatenate, SQL Query, SQL Select, Substring
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?
Answer Question
| June 10, 2009 6:55 PM
Concatenate, SQL Query, SQL Select, Substring
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 [...]
Answer Question
| August 4, 2010 6:16 PM
Concatenate, Database
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 [...]
Answer Question
| August 4, 2010 6:16 PM
Concatenate, Database
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 [...]
Answer Question
| June 9, 2009 2:46 AM
Concatenate, Microsoft Excel, Microsoft Excel formulas
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 [...]
Answer Question
| June 9, 2009 2:46 AM
Concatenate, Microsoft Excel, Microsoft Excel formulas
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 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
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 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
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??
Answer Question
| February 16, 2009 10:17 PM
Concatenate, Oracle 9i, Oracle 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??
Answer Question
| February 16, 2009 10:17 PM
Concatenate, Oracle 9i, Oracle 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?
Answer Question
| January 13, 2009 3:28 AM
Carriage Return Line Feed, Concatenate, CRLF, CRLF SQL2005, SQL, SQL Server 2005
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?
Answer Question
| January 13, 2009 3:28 AM
Carriage Return Line Feed, Concatenate, CRLF, CRLF SQL2005, SQL, SQL Server 2005
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
Answer Question
| December 23, 2008 1:06 PM
Concatenate, RPG/400, RPG/400 Field Concatenation, RPG/400 field 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
Answer Question
| December 23, 2008 1:06 PM
Concatenate, RPG/400, RPG/400 Field Concatenation, RPG/400 field validation
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 column [...]
Answer Question
| September 25, 2008 2:37 PM
Concatenate, T/SQL
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 column [...]
Answer Question
| September 25, 2008 2:37 PM
Concatenate, T/SQL
