DSXchange

Hey,

I have an FTP job that I want only to run when a certain file exists. I don't want the job to fail if it doesn't.

The "most efficient" way will depend on exactly what you want to achieve, whether the queries are run in the same database, and a number of other factors. For example, can you form the join (or union) of the three queries in the database itself? That would probably be very efficient, and ...

It is difficult to answer that without knowing what queries are you trying to run. You can use stage variables and define constraints. But it would be nice on your part if you could provide the type of queries that you would like to run on this sequential file. This would help us in giving you a be...

Hey,

I have a project in which there is a base query where I extract data to a sequential file in Dstage. Then up must run 3 seprate queries on that data. What is the most efficient way to do this?

Thanks,
Steve

naveendronavalli wrote:Oops! Sorry.

I missed a parethesis in the code. It should be

Code: Select all

DT_FLD = Ereplace(Trim(InLink.DT_FLD), " ", "-") 

Let me know if it worked.

Thanks,
Naveen.

Thanks alot Naveen. Works great! :D

Hey,

I have a timestamp column comming in from a source file as:

2006-02-01 00.00.00.000000

I need to have it come out as:

2006-02-01-00.00.00.000000

Currently my stage is doing a seq to seq. How do I format the timestamp properly?

Thanks,
Steve

Try using the debugger and stepping through the values on the output side of the FTP to see if you really have leading zeroes prepended to char fields at that point. Also, it looks like a "0" is put before and after the values - could it be the column separator; perhaps you could try usin...

How do you know that the padding is done in the FTP stage? Normally I would never expect a CHAR field to be automatically padded with leading zeroes so my first guess is that this is happening on your output. If you use a FTP stage and either write straight to a non-delimited, fixed width, no termi...

I am trying to FTP a sequential file and the columns that use CHAR and Timestamp are getting padded with zeros. There rows are supposed to be tab delimeted BTW. Original rows: 114 2006-02-01 00.00.00.000000 742 7565 74207469 226577044.42 158357477.37 114 2006-02-01 00.00.00.000000 862 4653 27876492 ...

I do not need to extract the timestamp of the file. there is an actual timestamp string in the txt file. thats all it holds. The only way you can use a variable in a where clause is using a job parameter. Not quite true because you can also use the variable to create an SQL file on the fly and then ...

I'm working on a project which requires me to read a timestamp from a file and then use that within a WHERE clause. How can I accomplish this?