Re[2]: Export/Import/Moving Projects

[admin]

Hi, All!

Please advise how can I easily recreate hash files when I migrate DS project from for examle NT box to UNIX box?


Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

[admin]

I guess the obvious answer (but you probably already thought of this) is to validate all jobs which use hash stages. If someone has an easier way, I would like to hear it as well.

What versions are you migrating from and to? Are you upgrading or staying with the same version? The reason I ask is that there are some cute little gotchas in the latest version of the ORAOCI8 plugin (version 3) that comes with DataStage 4.2.1 as well as in DataStage itself.

-----Original Message-----
From: Alexandre Stoulov [mailto:alexs@tern.ru]
Sent: Tuesday, 2 October 2001 5:25 PM
To: datastage-users@oliver.com
Subject: Re[2]: Export/Import/Moving Projects

Hi, All!

Please advise how can I easily recreate hash files when I migrate DS project from for examle NT box to UNIX box?


Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

[admin]

I have a job that I run which takes in a sequential file that contains a list of files and validates whether each file exists. If not, it creates the file for me. Anytime I have a new hash file, I add its name to the sequentail file and rerun the job. Here is the code: FileName = "g:EGARepository":AuditAppName:"HashFiles.txt"
OpenSeq FileName to FileVar

Else Call DSLogFatal("Could not open ":FileName,"Create Hash Files")

EOF = 0

Loop Until EOF

ReadSeq NewFile From FileVar

Then GoSub CheckAndCreate

Else EOF = 1

Repeat

Return

CheckAndCreate:

If NewFile = ""

Then Return

NewFile = TRIM(NewFile)

Command = "FILE.USAGE ":NewFile

Call DSExecute("UV",Command,output,returncode)

If output[1,7] = "Illegal"

Then

Command = "CREATE.FILE ":NewFile:" DYNAMIC"

Call DSExecute("UV",Command,output,returncode)

If returncode = 0

Then Call DSLogInfo(NewFile,"FILE ALLOCATED")

Else Call DSLogFatal(NewFile,"ERROR ALLOCATING FILE")

End

Else

Call DSLogInfo(NewFile,"FILE ALREADY EXISTS")

End

Return



Alexandre Stoulov wrote: Hi, All!

Please advise how can I easily recreate hash files when I migrate DS project from for examle NT box to UNIX box?


Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru




---------------------------------
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone with Yahoo! by Phone.