DSXchange

Thanks Ray

Hello All Source : File Target : Table UTC Time: Timestamp (yyyy-mm-dd hh:mm:ss) I have a reference table where i can get the offset numbers such as 11 or 10 based on the range lookup with the source data. Is there any inbuilt Datastage function i could use to add the offset numbers with the input t...

You can export the project, replace the string and import it back.

Take the project back up. it might create issue if you did mistake.

Notes: Import it in a new project and see how it looks like!

chandu123 wrote:Filename: `ls -name Historical Volumes*.csv #FilePath#`
Method: File pattern

Is it the same issue you have raised before?

By looking your command i doubt it may not work.

Is there any errors or warnings when you ran the job?

Sorry to ask, Have you changed the method to file pattern?

Now you have the space in the file names

can you able to create few test files without space and place it the same server and try to read it!

This will eliminate the file path issue. Next concentrate with the file space issue.

This is nothing to do with Datastage. Before use the command in the file stage, try with dos command line using ls command. for example ls \\pd4p-ccbv-w01\d$\Cognos\DATAMA~1\SOURCE~1\FCUNIT~1\*.CSV In the initial example you have mentioned space in the file name,whereas now so space. We don't know w...

chandu123 wrote:\\pd4p-ccbv-w01\d$\Cognos\DATAMA~1\SOURCE~1\FCUNIT~1\*.CSV

Can't you try like above?

try like below

//pd4p-ccbv-w01/d$/Cognos/'Historical Volumes'*.csv

chandu123 wrote://pd4p-ccbv-w01/d$/Cognos/Historical Volumes*.csv

May be the space issue in the file.

try like below

//pd4p-ccbv-w01/d$/Cognos/'Historical Volumes'*.csv

Or create few test files without space and try to read it.

Does it allow space in the folder name? Did you tried to view the data or ...? But it is returning 0 records. Is there any way to acheive this? When you execute the job in the director you can find the Datastage user name who triggered the job. The shared folder should have the access for this Datas...

To start with, print the values in the log and see how the query looks like after the variable has been passed?

May be space issue, or missing values .......

Once you are happy then use it in the job.

Are you using /EXEC option? Thank you battaliou for sharing this link. D:\IBM\InformationServer\Clients\Classic\dscmdexport /D=#DOMAIN_NAME# /U=#USER_NAME# /P=#PASSWORD# /H=#HOST_NAME# #PROJECT_NAME# #DSX_FILE_PATH##PROJECT_NAME#.dsx /V > #DSX_FILE_PATH##PROJECT_NAME#.log This is the command.

Methinks he is saying it is not 'the same command'. Means the command behaves differently ? Or Totally the different command ? As i said before, i copied the command from the Datastage director. That means , to me it is a same command. Even i tried the Export options from the Designer, none of them...

Thanks Ray, but is there any difference if the same command has been executed using command line vs command activity stage?