DSXchange

spracht wrote:Can't remember, try to use

DSJobStartDate
DSJobStartTime
DSJobStartTimestamp

in your file name specification. like

file#DSJobStartDate#.txt to get 'file_2003-10-23.txt' as your file name.

that makes sence....but where do i put that to rename the original data file? after job completion.....

spracht wrote:A couple of weeks ago, Michael Hester pointed out that you can use DS makros just like job parameters, surrounded by hashes, to achieve that.

How would I search to find that post so that I can figure it out?
What was the tipc subject?
Jim

I have a process currently in SQL server that runs a query and outputs a string of date time information into a batch file. Then I run the batch file to rename a load file. I am moving away from sql server and using DataStage as my data processing tool of choice. Is there a way for data stage to dyn...

I have a process currently in SQL server that runs a query and outputs a string of date time information into a batch file. Then I run the batch file to rename a load file. I am moving away from sql server and using DataStage as my data processing tool of choice. Is there a way for data stage to dyn...

I think that I have found my problem. The row length of my records is 1373 where an average txt file can only handle around 1125 characters. My records have been forced to wrap causing my error. Thanx for the help
Jim

I am tring to define a sequential file to import into a SQL server database. I cant seem to get the file definition correct. I use the layout that I was given by the data provider inserting the length of each coloumn. When I try to use it I get the error to many coloumns in record. I have defined th...

I am tring to define a sequential file to import into a SQL server database. I cant seem to get the file definition correct. I use the layout that I was given by the data provider inserting the length of each coloumn. When I try to use it I get the error to many coloumns in record. I have defined th...

I am tring to define a sequential file to import into a SQL server database. I cant seem to get the file definition correct. I use the layout that I was given by the data provider inserting the length of each coloumn. When I try to use it I get the error to many coloumns in record. I have defined th...

I am tring to define a sequential file to import into a SQL server database. I cant seem to get the file definition correct. I use the layout that I was given by the data provider inserting the length of each coloumn. When I try to use it I get the error to many coloumns in record. I have defined th...

Yup u are right i found it. Thanx Jim The target table on the SQL Server side? That would typically be as simple as checking off the "Create Table" in the stage you use to write to the target. For SQL Server - assuming you are using ODBC - the "General" tab of the "Input&quo...

I have a flat file that I want to import into a SQL server. I have defined the flat file threw manager. How do I get it to make the table automatacly?
Jim

I have a flat file that I want to import into a SQL server. I have defined the flat file threw manager. How do I get it to make the table automatacly?
Jim

I think you are right, but because I am going from a system without NLS to a system with NLS I think I will be ok. The process you described worked well. Thanx for the help Jim Pey, Take into account that Datastage will not let you migrate from one NLS system to the other but you can trick him by ed...

I am trying to migrate my jobs from one server to another, having both DataStage servers on the same version. The only difference is that I enableled NLS on the new server. How do I move the jobs and enable the NLS on them?

Jim

quote: Originally posted by inter5566 [br]Jim, When you specify the R option with the trim statement, you need to pick a value you want to -R-emove. Perhaps DS assumed that you wanted to remove nulls. Either way, I believe that the R option will never remove all characters in the string, it reduces ...