DSXchange

How many columns are there in your record? Read that post by roy carefully and convert it into code. You need a basic routine that does something like this Strt = Arg1 End = Arg2 Rcd = Arg3 Delim = "," FOR n = Strt TO End Ans:=n : Delim : End : Delim : Rcd : Char(13) : Char(10&...

True. Make sure you have indices set up on the joining keys. I have successfully joined four tables (left outer join queries) along with data validations (lookups) in the user defined sql that retrievs millions of records in less than 10 seconds with 20+ columns.

Design the job in such a way that it does not give out warnings. Capture rejects in a file. Utilize the email notification if the reject file size is greater than zero. You can also set the warning limit to 1. This way the job will abort even if you have a single warning.

The OP should get back to us with more updates on where exactly he/she is stuck. He has more than few different ways of going about doing it.

Even if a database is not involved, this data can be loaded into a temp table and then a user defined sql can be written on it. I think going this way would turn out to be a very dynamic/flexible solution in which you dont need to hardcode the range values.

You can check for the file size via basic command STATUS. It returns different information in a dynamic array. The size info is present in the 6th entry in the array. Try searching for the keyword STATUS. A couple of weeks ago i posted a routine that utilizes the STATUS command to check if the file ...

To capture duplicates you need to work with stage variables and constraints. Sort the incoming data, detect the change via use of two stage variables and flag the record thats identical. Then in the constraint of the link where you plan to capture duplicates, use the flag value.

Once you install the VC client you will be able to view the documents as well. Ask your Admin to install that for you or do it yourself if you have the privelages.

Seems like there is a space before the file name
ftp /usr/ascential/work/OutputFiles/ReportFactory/ G_ws_mov_hist_out.txt [/b]

Have a shell script do the execution of the sequence. And this shell will be executed using crontab. As Ray has mentioned you need to have a master control to perform this. The shell in this case would act as a master control and would wait for each job/Sequence(which ever you are executing) to be f...

I kind of agree with Kim. Just by looking at the post count we can tell weather the person is new or fairly old here at dsxchange. Depending upon that we can either politely direct the poster to the right forum or do not answer his post at all. This will force the slackers to take these rules seriou...

Increase the scale to 6.

The job needs to finish as already pointed out to you. Using the function inside the transformer will not get you the required output as the job is still in execution mode. If you want to use it in the transformer itself then specify another link with two column with exactly the same constraint as t...

You can also add a running number in datastage by adding a column and providing its derivations as @INROWNUM

Craig is right. ICONV/OCONV operations are to be performed on both date and time parts seperately. In your case, the time looks fine, its just the date part you need to be worried about. Just do this OCONV(ICONV(LEFT(L1.END_DT,10),"D/YMD[4,2,2]"),"D-YMD[4,2,2]"...