Hi All,
I came across below function in my existing code. I want to analyze what exactly this does and what @FM refers to? Any idea?
Ereplace(Trim(Convert(@FM ,"", cmd_List_Files.$CommandOutput)), p_HrSrcFileDir , "")
Regards,
Atul
What is @FM
Moderators: chulett, rschirm, roy
What is @FM
Atul
Re: What is @FM
@FM --> Field mark: CHAR(254). Same as @AM.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
@FM is not a function - it is a system variable, and is preloaded with the ASCII code 254. Historically, in the UniVerse database, this character is the principal delimiter in a special kind of delimited string called a "dynamic array". Since DataStage was originally built on UniVerse, @FM is still seen in many places.
When DataStage reads a multi-line file in a single operation, the line terminators are converted automatically (by DataStage) into field marks. That way it doesn't matter whether you've read a UNIX file or a DOS file - the resulting string is exactly the same. Your Convert() function is removing any field marks (replacing them with "").
When DataStage reads a multi-line file in a single operation, the line terminators are converted automatically (by DataStage) into field marks. That way it doesn't matter whether you've read a UNIX file or a DOS file - the resulting string is exactly the same. Your Convert() function is removing any field marks (replacing them with "").
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.