DSXchange

Thanks for the help,

I proved with that routine and the problem dont be resolved, i remake my routine and controlled the finish blank line ..

oCad = ""

For i = 1 to Veces
oCad = oCad : Cadena : Char(10)
Next i
Ans = oCad


Thanks...



Miguel Seclen
Lima - Peru

Hi, I have a process that read a text file, in this record in a position it has a value, it means the number of records will be repeat, example F1 F2 F3 F4 HELLO 092983 3 OTHER VALUES This record will be convert in three records... F1 F2 F3 F4 HELLO 092983 3 OTHER VALUES HELLO 092983 3 OTHER VALUES ...

Hi,

Thanx for your answers, the function used is

oConv(@DATE,'D/E').

Miguel Seclen
Lima - Peru

Hi, I have a curious problem, my batch generate a log file using DSExecute to define it, when the first job run i get the date/time and write the file, when finish all jobs i write the date/time too. The problem is when the batch start Monday at 23:00 pm and finish Tuesday at 05:00 AM, the first dat...

Hi,

In the job mainframe can't define a reject link, in job server i mark the check box.. but in the mainframe what is the choice ???



Miguel Seclen
Lima - Peru

how obtain the datetime of the finish job?

there is a routine DSGetJobInfo but this return the JOBSTARTTIMESTAMP...

Is there a routine that return the datetime when the job finish ???

Miguel Seclen
Lima - Peru

Hi, i have a process that create a hashed file, when its ending make a warning in the log: EGCuotaTransac..TRANS1_DOCS: Synchronization error Resource = EGCuotaTransac..CuotaTransac_H1.a_CuotaTransac_H1, CurWave = 1, LastWave = 0, Expected 5 what means?? thanks for your help. Miguel Seclen Lima - Peru

Hi Ray,

What is the difference between the commands CREATE.FILE y mkdbfile??

Thanks. [8D]

Miguel Seclen
Lima - Peru

Miguel Seclen
Lima - Peru

Hi World, What is the best way to create a hashed file using the Hashed Stage and the Create Options.. there are many kinds of Hashed but what is the fast to lookup ? I want to create a hashed with 2 millions of records, with 8 fields, the record length is 83, the 20 first positions are the key .. a...

Hi MAT

I work with DB2/390 and the timestamp format is

yyyy-mm-dd-hh.mm.ss.nnnnnn
2003-03-07-19.14.04.002959

[:D][;)]

Saludos



Miguel Seclen
Lima - Peru

Hi,
Your NT has configured the FTP Services???

Saludos



Miguel Seclen
Lima - Peru

Hi Melinda, I had the same problem in the past, when i scheduled my jobs and never run, With the Ascential support discover the reason, inside the folder projects there is an directory called &COMO&, you have to change the permission to 777. After change try to schedule some job. I hope this...

Hi Nilotpal

I use the mailx with the follow sintax:

> mailx -s 'Subject' 'Email_Address' < /msgs/NomArch.txt

Where /msgs/NomArch.txt contains the body email text..

I hope this help



Miguel Seclen
Lima - Peru

Hi Kiran You can use a UNIX Shell, define variables that contains the parameters, example, MyPaht=/home/data/info/files/december MyUser=dstage MyFile=Data_20021215_Cancel.txt MyBD=server2.myconection when you run the job, use the command > dsjob -run -mode NORMAL -param PATH=$MyPath -param USER=$MyU...

i'm trying to connect to SQL Server 2000, i changed the .odbc.ini to create the conexion, when i use the Manager to test the DS Conexion, show me an error about the user or password are wrong.. my conection in the .odbc.ini is: [TData] Driver=/home1/dsadm/Ascential/DataStage/DSEngine/../branded_odbc...