DSXchange

I want create a table and load the data from another table on the same database. Hence I am planning to run SQL query as below. Which stage or method should I use to perform this? Please suggest.

Create table Table1 as (Select * from Table2);

yes it is the same issue. I tried to achieve it in a different way and got different error. Now I have logged ticket with the support. Will update the outcome here!

My Datastage job is not running under dsadm user. Instead it is running with my userid. How can I change it to run with USUSER=dsadm?

I am getting this error while trying read files from a network location in sequential file stage. I am not able to figure out if this issue is related to the credential mappings and engine credential setup for dsadm or if the issue with access to files? Please advise. Filename: `ls -name Historical ...

Yes i have changed the method to File Pattern and also set the environment variable to read File pattern as file set. Below are the warnings: Sequential_File_0: When checking operator: No files found for pattern. Sequential_File_0: When checking operator: Fileset C:/Windows/TEMP/import_tmp_91445e0be...

The file names which I mentioned in my previous post without spaces are the short names of the files which I got them using this command in cmd line: cmd /c for %A in ("\\pd4p-ccbv-w01\d$\Cognos\Data Manager\Source csv Files\FC Units Shipped\Historical Volumes*.csv") do @echo %~sA Coming t...

I tried ls on command line as mentioned above and it listed all the files in the directory and they are: //pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-APR-14.csv //pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-AUG-13.csv //pd4p-ccbv-w01/d$/Cognos/DAT...

I tried the above one and got the same message. I wonder if there some issue with the Datastage itself when reading FilePattern from network location? Since I am able to read single file successfully but not FilePattern.

I forgot to mention that I tried Sura's suggested format of adding quotes and it didn't work. Thanks for sharing me about 8.3 filename. I found though command line query that the short names for the files are something like this. \\pd4p-ccbv-w01\d$\Cognos\DATAMA~1\SOURCE~1\FCUNIT~1\HISTOR~1.CSV \\pd...

I also tried putting the file path in the parameter and using it which made no difference.

#FilePath#\Historical Volumes*.csv

I tried using below formats and still didn't work. //pd4p-ccbv-w01/d$/Cognos/Data Manager/Historical Volumes*.csv '//pd4p-ccbv-w01/d$/Cognos/Data Manager/Historical Volumes'*.csv '//pd4p-ccbv-w01/d$/Cognos/Data Manager/Historical Volumes*.csv' "//pd4p-ccbv-w01/d$/Cognos/Data Manager/Historical ...

I am able to access single file using sequential stage but not multiple files using File Pattern method. This makes me feel like there is no issue with the access to the directory on the network.

I am trying to read multiple files from a network location (not on the same server where the Datastage is installed). I am using sequential file stage: File Pattern: //pd4p-ccbv-w01/d$/Cognos/Historical Volumes*.csv Read Method: File Pattern But it is returning 0 records. I read in the forum that fi...

My SQL is "Select #Var1# as Variable1 from dual;" where Var1 is the job parameter (derived from User variable activity). Can't we use job parameter in select SQL?

My sequence has User variables activity followed by a Job Activity. I have set the job parameter of the Job activity using User variable set in the previous step. Var1 = UserVariables_Activity_1.Var1 I am using this variable in the source sql of the job as below: Select #Var1# as Variable1 from dual...