DSXchange

Create a job that takes a the filename and date parameters and in the transformer use SetJobUserStatus() to set a proper status that will be a concatenated filename and date. In the sequence you can retrieve the returned status with .$UserStatus and pass it to the job that contains FTP stage. Pleas...

Hi, I am using FTP stage. File to be FTPed to the NT Server from Unix platform. file Naming convention would be: FileName(Date) for FileName - Job parameter Date - Job parameter but needs to be set at the run time. How can i set the job parameters at run time??? Thanks for ur replay in adavance. Reg...

Hi DSGurus,

Can any one help me, how to use these functions which exists in repository

mksqlassoc
mksqlcol
mksqlcon
mksqlfile
mksqlprm
mksqlrefer
mksqluniq

Thanks

Vinod

Hi, I have got the solution in changing the .profile LIBPATH in home directory Before it is pointing somewhere. PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH LIBPATH=/baselwb/dsadmhome/Ascential/DataStage/DSEngine/lib export LIBPATH if [ -s "$MAIL" ] # Th...

When I run dsjob.exe then I get the following error 0509-036 Cannot load program ./dsjob because of the following errors: 0509-150 Dependent module libvmdsapi.so could not be loaded. 0509-022 Cannot load module libvmdsapi.so. 0509-026 System error: A file or directory in the path name does not exist...

When I run dsjob.exe then I get the following error 0509-036 Cannot load program ./dsjob because of the following errors: 0509-150 Dependent module libvmdsapi.so could not be loaded. 0509-022 Cannot load module libvmdsapi.so. 0509-026 System error: A file or directory in the path name does not exist...

hi Kenneth Bland, I know these steps has to be followed.. 1. dsjob -run <<project name >> <<job name>> 2. dsjob -report <<project name >> <<job name>> 3. dsjob -logdetail <<project name >> <<job name>> 4. (cat text.txt; uuencode /tmp/reports/prod_report.$date prod_dailyreport.txt) |mailx -s "Da...

Hi, I need a unix script to schedule 5 jobs at a particular time in sequence one after another and the status should be updating a table which consists of table name and status as attributes. Even if one warning comes, the status should be updated as failed and the job report and job logs have to be...

Hi DS Gurus,

I have hash files outside the repository. How I can do usage analysis ?

Thanks

Vinod

Hi,

How can I abort a job inside a transformer?

Shall I can use UtilityAbortToLog routine to stop the job?

Vinod

Hi,

I want to write data into a text file which is obtained from ds administrator command line.

for eg

SELECT * FROM DS_AUDIT

The results has to be populated into a text file.

Any solution

Thanks

Vinod

Hi ray,

This is the warning I got, no information about the hash file and only just abnormal termination of job name alone give in the log.

"Abnormal termination of stage LOADIPXIPStagingRecon.SCI_D_UK_ORG_MAP_18264.LC_IPXIP_Recon detected"

Thanks

vinod

Thanks all, I am doing migration 71. to 7.5. I have 5 hash files collected by a link collector and populated into a seq file. When running on 7.5 it shows abnormal termination. Then I had made a fix, by inserting seq files after hash files followed by link collector. My question is why it is not wor...

Hi DS Gurus,

I need a routine to validate a hash file.

Thanks

Vinod

Hi DS Gurus, I am calling a DB2 SP in a db stage. This SP is built with some Dynamic SQL statements but Execute immediate statements were not used in it. This procedure works fine in database but while executing in dtastage it shows warning (Prepare or Execute Statement is blank or empty SQLSTATE=42...