Topic
  • 2 replies
  • Latest Post - ‏2014-02-09T01:05:54Z by Affordable_Dbasic_Programmer
SystemAdmin
SystemAdmin
7754 Posts

Pinned topic Problem in creating Hash File Using DS Basic

‏2006-03-08T21:21:21Z |
hi,

i have this hash file job designed using Datastage Basic routine.
this job populates a hash file 'DbMbrHash' from the sequential file 'dbmbr.txt'.

now the routine is such that the Hash file has to be present so that its just opened and written into. No i want to get rid of the necessity of hash file being persistently present. So I am adding the
EXECUTE 'CREATE.FILE DbMbrHash'

but this doesnt seem to work. why is that?? and suggestions are invited

code:1:cedafedb10OPENSEQ PROJECT_HOME:'/seq/dbmbr.txt' TO F.SEQ ELSE
Call DSLogInfo("Unable to open ":PROJECT_HOME:'/seq/dbmbr.txt',"Output")
STOP
END
*
TCL = 'LogTo ':FIELD(PROJECT_HOME,'/',5)
*
Call DSExecute("TCL", TCL, ScreenOutput, SystemReturnCode)
Call DSLogInfo("Logged to Project ":FIELD(PROJECT_HOME,'/',5), "LOGTO")
*
****EXECUTE 'CREATE.FILE DbMbrHash*****
OPEN 'DbMbrHash' TO F.HASH THEN
EXECUTE 'CLEAR.FILE DbMbrHash'
END ELSE
Call DSLogInfo("Cannot Open DbMbrHash","ERROR")
STOP
END[/code:1:cedafedb10]

thanks
Sumeet
Updated on 2006-03-11T10:22:48Z at 2006-03-11T10:22:48Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Problem in creating Hash File Using DS Basic

    ‏2006-03-11T10:22:48Z  
    I've responded at length to this question at [url=http://www.dsxchange.com]DSXchange[/url]; please refer to that answer.
  • Affordable_Dbasic_Programmer
    2 Posts

    Re: Problem in creating Hash File Using DS Basic

    ‏2014-02-09T01:05:54Z  
    I've responded at length to this question at [url=http://www.dsxchange.com]DSXchange[/url]; please refer to that answer.

    Shouldn't the link be like this?:

    <a href="http://www.dsxchange.com">DSXchange</a>

    DSXchange

    Robert Norman, Datastage BASIC Programmer/Analyst

    ROBERT NORMAN AND ASSOCIATES
    23441 Golden Springs Dr., #289, Diamond Bar, CA 91765
    (951) 541-1668
    ICE@KEYWAY.NET
    http://universe-basic-programming.webstarts.com
    http://users.keyway.net/~ice/index.html
    http://www.affordablemultivalueprogramming.i8.com
    Affordable computer consulting services for these environments and languages:

    Computer programming & software development in Universe BASIC for Rocket Universe, in PICK/BASIC for Rocket D3, in UNIBASIC for Rocket Unidata, in R/BASIC (REVELATION BASIC) for REVELATION TECHOLOGIES REVELATION, in JBASIC (JBC or JBASE BASIC) for TEMENOS JBASE, in DATA/BASIC for Northgate REALITY, in MV BASIC (Multivalue Basic) for Intersystems Cache Multivalue, and QMBASIC for Ladybridge OPENQM (QM).

    Affordable programming services for UNIVERSE, UNIVERSE BASIC, UNIDATA, UNIBASIC, PICK, Advanced PICK, D3, PICK/BASIC, PICK BASIC, R83, CACHE, MULTIVALUE BASIC, MV BASIC, MVBASIC, PRIME INFORMATION, INFO/BASIC, PIOPEN, jBASE, jBC, jBASE BASIC, jBASIC, MENTOR System, DATA/BASIC, DATABASIC, DATA BASIC, OPENINSIGHT, BASIC+, OPENQM, QM, QMBASIC, Power95, REALITY System, REVELATION, Advanced REVELATION, AREV, R/BASIC, REVELATION BASIC, WebSphere DataStage, DSBASIC, DataStage BASIC, MvBase, MV*BASE, Ultimate, MentorPro, MENTOR/PRO, MENTOR PRO, PC/OS, mvEnterprise, UniVision, MvON, MAVERICK, COLUMBIA ULTIMATE COLLECTOR SYSTEMS, CUBS, DATAFLO, DATATEL, MANFACT, MADIC, MULTIVALUE

    Updated on 2014-02-09T01:18:25Z at 2014-02-09T01:18:25Z by Affordable_Dbasic_Programmer