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
Page 1 2 
Go
New
Search
Tools
Search Results: (23 matches) New Search Login/Join 

Discussion Topic  RE: iDM - Invoking a function in Oracle DB (in iWay Software Product Forum on Focal Point) by Nan
Clif, U had mentioned that Oracle sequence will be listed as Stored procedures. I don't see them. ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Datamigrator Developer Questions :-) (in iWay Software Product Forum on Focal Point) by Nan
Hi, I am an iWay person who has recently started working with DM. I am developing an interface for ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [SOLVED by case] DataMigrator - Create New Target/Table (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Sorry for the delayed response. I had opened a case and it was a bug --> some of my source fields w......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED by case] DataMigrator - Create New Target/Table (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Hi, I am creating a data flow that polls a source table. I want to create the target table during t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Thanks Dan, JG. I am using TRIM( 'L', IDOCNUMBER, 50, '0', 1, 'A50V' ) where IDOCNUMBER is the sour......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Thanks Dan. About this HOLD file, is this code I need to write and cannot use the synonym generator......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
thats my requirement :-) when moving from source to target, I need to remove extra spaces....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
The max length for this field is 50, but there will not be 50 characters in them always.. there migh......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
this is a data field in my process flow that I created in datamigrator. why I need to remove traili......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Remove Leading Zeroes and Trailing spaces (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Hi, I need to remove leading zeroes and trailing spaces. I am able to remove leading zeroes using......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Thanks Dan.. I do have MISSING in the source. Can you please explain what u mean by changing the pro......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Partial Good news ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
I changed it to FILENAME=OBIDOCDETAILS, SUFFIX=SQLMSS , $ SEGMENT=OBIDOCDETAILS, SEGTYPE=S0, $ ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
oops, when I choose HYYMD (with milliseconds), thats what gets written.. I think I need to go and ma......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
I was off Friday ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Dan, Yes I created using the synonym generator. I am not doing any transformations on these date c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Forgot to mention Oracle datatypes are TIMESTAMP and the source SQLServer datatypes for these colum......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Help - SQLServer to Oracle - DATETIME (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Hi, May be a simple question, pardon me ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Remove leading zeroes in Datamigrator (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Wow, figured it !!! using TRIM we can remove leading characters not just spaces ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Remove leading zeroes in Datamigrator (in WebFOCUS/FOCUS Forum on Focal Point ) by Nan
Hi, I have a varchar column from source table that might have leading zeroes. I need to strip the ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2  

Focal Point    Focal Point Forums    Search    Search Results

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