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
Re[2]: Export/Import/Moving Projects
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
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
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.
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.