Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums    Search    Search Results
Go
New
Search
Tools
Search Results: (19 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED] Data Migrator Synonym cannot read Source File with carriage return (in iWay Software Product Forum on Focal Point) by AnnaR
FYI - The solution was to add RDELIMITER=0x0D to identify correct end of line character....
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  [SOLVED] Data Migrator Synonym cannot read Source File with carriage return (in iWay Software Product Forum on Focal Point) by AnnaR
I have a source file that includes CR (carriage return) as end of line character. Can't find any set......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  ETL Flow not reporting on truncated data (in iWay Software Product Forum on Focal Point) by AnnaR
Hello, Here is the scenario; sometimes I receive source files with columns sizes larger than the ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  [CLOSED] TRUNCATE TABLE in Data Migrator stored procedure (in iWay Software Product Forum on Focal Point) by AnnaR
I wrote A sgtored procedure in Data Migrator that looks as the below: ENGINE DB2 SET DEFAULT_CONNEC......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: SQL RIGHT FUNCTION USED IN SELECT STATEMENT (in iWay Software Product Forum on Focal Point) by AnnaR
Thank you Clif. In your statement "In prior releases you could use a DBMS SQL Flow to write dialec......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  SQL RIGHT FUNCTION USED IN SELECT STATEMENT (in iWay Software Product Forum on Focal Point) by AnnaR
Hi, In a flow, I am trying to use RIGHT function in SQL select statement for the source, as: SELECT......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Build report with LEFT OUTER JOIN (in WebFOCUS/FOCUS Forum on Focal Point ) by AnnaR
Thank you all for comments and tips. Daniel, the files are a mix; there could be a left join from c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Build report with LEFT OUTER JOIN (in WebFOCUS/FOCUS Forum on Focal Point ) by AnnaR
Hi All, I am struggling with using JOIN function in WebFocus report to get result as left outer join......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Synonym / Flow Names (in iWay Software Product Forum on Focal Point) by AnnaR
I learned that synonyms, though created in different application folders in Data Migrator, CANNOT ha......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Web Focus File Definition with OCCURS (in iWay Software Product Forum on Focal Point) by AnnaR
Thank you all for suggestions and comments. Based on your responses, I gather that OCCURS cannot be ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Web Focus File Definition with OCCURS (in iWay Software Product Forum on Focal Point) by AnnaR
Hi All, I am trying to define a synonym for the following csv file: HDR,10000000,111225,00401,000,6......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: using column name as data in row record (in iWay Software Product Forum on Focal Point) by AnnaR
Sorry for late response. I used another software to accomplish this. However, here is a sample data:......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  using column name as data in row record (in iWay Software Product Forum on Focal Point) by AnnaR
One of the files, i am working with, has 7 columns, with names representing a day of the week in dat......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Identifying Filename in Synonym (in iWay Software Product Forum on Focal Point) by AnnaR
Thank you! This is exactly what i was looking for....
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Identifying Filename in Synonym (in iWay Software Product Forum on Focal Point) by AnnaR
I have a process that loops thru multiple csv files and I need to capture the filename as part of th......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  [CLOSED] Passing variables (in WebFOCUS/FOCUS Forum on Focal Point ) by AnnaR
I have a synonym that has summary data and raw data in the same file. I need to create a report that......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Concatenate syntax (in iWay Software Product Forum on Focal Point) by AnnaR
Found the difference: || trims the column while | does not: for instance: var1 = 'cat ' var2 = 'dog'......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Concatenate syntax (in iWay Software Product Forum on Focal Point) by AnnaR
What is a difference in using | vs || to concatenate two columns?...
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Email Message Attachments (in iWay Software Product Forum on Focal Point) by AnnaR
Just wondering if there is a workaround. Data Migrator allows exporting reports to Excel file, howev......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.