DSXchange

A good start will be the online manuals , they have lots of information on Routines and how they work.

Are you using any FTP softwares to look into the file??

Are you supplying the file name as a parameter or it is hardcoded in the job?

Yes.

May be u can try to use a SEQUENTIAL file which gets locked automatically if one job is using it. Or research on lockign the file till the frst job is complete.

Use the function - DSGetJobInfo

Or you can have Asecntial CLient installed on Windows and run ti from there

Int(Expression)

Int(2.3) = 2

Search for "libvmdsapi.so: open failed: No such file or directory " in the forum.

http://dsxchange.com/viewtopic.php?t=98 ... 8c51d26a33

Design the second job in a way that the first stage of the job will run a job variable as a user defined SQL. Now when u call this job from the master job u will have to specify the job variable. Pass the query column as the variable when u call the second job. You can also write a routine which wil...

As far as I know it should not be , check if there are some extra spaces or any extra characters in ur UAT data?

Store the reference in three different hashed files. Hashed file 1 - Col1 as key , Hashed file 2 - Col 2 as a key and so on. Compare the first col1 (hashed file1) in the first stage and store the result in a stage variable , pass it on to the next stage and then compare the col2 (hashed file2) and s...

Assuming that the query stored in the table is a uniform query (you know the output of it - means what format the results will be) you can develop two jobs. The second one gets called from the first one. The first one runs and stores the query in a variable and passes it on to the next job. the next...

Did u try loading it to a file? Do u still get the same error?

Hi, Please any one guide me how to use Folder stage to extract number of files from folder. My requirement is to extract 10 files which contains in one folder and load into one single file. Note:the file layouts are different from each File. Can any one help me out in this matter i will greatly app...